Description

Create Statements

------------------------------------

1.    Write a query that creates at least eight tables.   

2.    Make sure some of the tables are related, i.e. they have a foreign key relationship. 

3.    All your tables must have a primary key.

4.    Use the SET or the ENUM data type in at least one of your tables. 

5.    Use the Date or Date time data type in at least one of your table creations. 

Insert Statements

-----------------------------------

1. Write an INSERT statement to insert at least 10 records or rows in each of the tables you have created above. 

Select Statements

-----------------------------------

1. Write three SELECT statements that use the JOIN operator.
2. Write three SELECT statements that use the WHERE clause to search for a record in your  tables you created
3. Write a SELECT statement that uses the GROUP BY Clause and the COUNT function. 
4. Write a SELECT statement that uses MAX or MIN function
5. Write a SELECT statement that uses an aliases for a column or a table name
6. Write a SELECT statement that uses a RANK function. 
7. Write a SELECT statement that uses a sub query. 

UPDATE Statement

------------------------------------------

1. Write five UPDATE statements

DELETE Statement

-----------------------------------------

1. Write five DELETE statements.