The TblMembers Table Contains Six Fields

question 20

Essay

The tblMembers table contains six fields. The LastName, FirstName, and MemberType fields contain text. The MemberID, JoinDate, and Fee fields contain numbers. The MemberType field contains one of the following letters: F for Family membership, A for one Adult membership, Y for one Youth membership, and S for one Senior membership.
-Write a SQL SELECT statement that selects only the records for the Senior members.Select all of the fields.

---

Definitions:

Post Reference Notation

A notation in a ledger to indicate the source of each entry, facilitating the traceability and verification of transactions.

Ledger

A book or electronic record used to record all of a company's financial transactions in accounts.

Ledger

A book or collection of financial accounts where transactions are recorded, typically categorized by type.

Journal

A book or digital record where all financial transactions are initially recorded, also known as the book of first entry.