Members the TblMembers Table Contains Six Fields. the LastName, FirstName, and FirstName

question 9

Essay

Members
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.

---

Definitions:

Lymph System

A network of vessels, tissues, and organs that helps to maintain the body's fluid balance and protect it from infections.

Digestive System

A group of organs working together to convert food into energy and basic nutrients to feed the entire body.

Plasma Proteins

Proteins such as albumins, globulins, and fibrinogen that circulate in the blood plasma.

Interstitial Fluid

The fluid that fills the spaces between most cells of the body, providing a means of delivering nutrients to cells and removing waste products.