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 the MemberID,LastName,and FirstName fields for all family members.Sort the records in descending order by the JoinDate field.

Question

Quizplus · Accepted Answer

The Answer of 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 the MemberID,LastName,and FirstName fields for all family members.Sort the records in descending order by the JoinDate field.

The TblMembers Table Contains Six Fields