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 only the records for the Senior members. Select all of the fields.
What will be an ideal response?
SELECT MemberID, LastName, FirstName, JoinDate, Fee,
MemberType FROM tblMembers
WHERE MemberType = 'S'
Computer Science & Information Technology
You might also like to view...
A(n) ________ data type is an old or outdated data type that is still used, usually because it still works for the user, even though newer technology or more efficient methods exist
Fill in the blank(s) with correct word
Computer Science & Information Technology
The legal document that orders a person to turn over records or documentation to a representative of the government is called what?
a. Writ b. Warrant c. Subpoena d. Court Order
Computer Science & Information Technology