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:

Accounting Basis

The method used to record the financial transactions of a business (e.g., cash basis, accrual basis).

Pay Back

The period of time it takes for an investment to generate enough returns to recover the original investment cost.

Fixed Costs

Expenses that do not vary with the level of production or sales, such as rent or salaries.

Accounting Break-even

The point at which a company's total revenues exactly match its total expenses, indicating no net profit or loss from operations.