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 allows the user to select the members with a fee greater than or equal to the fee amount provided by the user. The query should select the MemberID, LastName, FirstName, and Fee fields.
What will be an ideal response?
SELECT MemberID, LastName, FirstName, Fee FROM tblMembers
WHERE Fee >= ?
Computer Science & Information Technology
You might also like to view...
A picture positioned directly in the text at the insertion point is a(n) ________ object
Fill in the blank(s) with correct word
Computer Science & Information Technology
What is the binary version of the decimal number 49?
A) 10110001 B) 00110001 C) 00110010 D) 00111010
Computer Science & Information Technology