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
   429   430   431   432   433   434   435   436   437   438   439