a. CREATE A query that is based on two tables and includes both an arithmetic and a special operator in the conditional expression USING THE FOLLOWING TABLES

b. CREATE A query that is based on more than two tables and includes both an arithmetic and a special operator in the conditional expression. Both the arithmetic and the special operator must be different from the ones used in part a USING THE FOLLOWING TABLES

c. CREATE A query that includes a sub-query USING THE FOLLOWING TABLES

d. A query that contains the GROUP BY clause, one of the aggregate functions, the WHERE statement, and the HAVING operator USING THE FOLLOWING TABLES

e. CREATE Two additional complex queries designed by you that are different from the above. A complex query is based on two or more tables and includes either several conditions or a subquery (or both) USING THE FOLLOWING TABLES

mysql> SELECT -FROM CLUB; | CLUB_CODE | STREET_ADD I CITY I STATE I ZIP-CODE I C001 I C002 I C003 | VA | 21313 | 8421 Braod St | 2300 Vantage Dr | 2300 Vantage Dr Mclean Woodbridge VA 22101 Woodbridge | VA 22101I 3 rows in set (0.00 sec) mysql> SELECT -> FROM MEMBER; | MEMBER-ID I FIRST-NAME I LAST-NAME 1 CLUB-CODE I l 123456 l 123457 | 123458 I C001 I C002 I C003 3 rows in set (0.00 sec) mysql> SELECT [>FROM STAFF; | STAFF-ID ? FIRST-NAME ? LAST-NAME | PHONE-NUM 1 CLUB-CODE I | Gomels | Kardashian | 8014569524| C003 | Bitt I T52636 Selena | 8014569523| C002 T52637 Kim T78946 Brad | 8014569878 | C001 3 rows in set (0.00 sec) mysql> SELECT -FROM DEPARTMENT: I DEP-CODE I DEP-NAME I DEP-PHONE-NUM 1 CLUB-CODE I D002 | BASKETBALL 7039534697 | VOLLYBALL | 7049534698 | FOOTBALL 7039534696 C002 CO03 C001 I D003 D001 3 rows in set (0.00 sec)