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

question 12

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 only the records for the Senior members. Select all of the fields.

---

Definitions:

Specific Gravity

The ratio of the density of a substance to the density of a reference substance, usually water for liquids and solids, and air for gases.

Urochrome

A pigment that gives urine its yellow color, a byproduct of the breakdown of hemoglobin.

Anuria

A condition characterized by a failure of the kidneys to produce urine.

Cystogram

A diagnostic X-ray examination of the bladder after the introduction of a dye, used to visualize and assess bladder function and structure.