MembersThe 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 Family member accounts and sorts them in descending order by JoinDate.

What will be an ideal response?

SELECT MemberID, LastName, FirstName, JoinDate, Fee,
MemberType FROM tblMembers     WHERE MemberType = 'F'     ORDER BY JoinDate DESC