Page 434 - TP_IT_V1.0_C10_flipbpookl
P. 434
3. Follow the given instruction to complete the project:
The following table shows the members of a community centre.
Number Last_Name First_Name DOB Member_Type Payment
001 Singh Ashish 03/04/77 Senior Y
002 Mirza Gautam 16/06/92 Junior N
003 Chouhan Kunal 02/11/85 Senior N
004 Chetan Rahul 06/07/74 Senior Y
005 Bhagat Manish 12/10/89 Junior Y
Create a query for community centre which wants to find the members according to the following criteria:
Member_Type is not ‘Senior’ and Payment is ‘N’.
Member_Type is not ‘Senior’ and Payment is ‘Y’.
Member_Type is not ‘Junior’ and Payment is ‘Y’.
Member_Type is not ‘Junior’ and Payment is ‘N’.
432 Trackpad Information Technology (Ver. 1.0)-X

