Write the SQL statements that you plan to use in the code:

DDL  - SQL Statement to drop table:

 

DDL - SQL Statement to create table:

 

DML - SQL Statement to insert a new row:

 

DML - SQL Statement to retrieve all columns from all rows:

 

DML - SQL Statement to retrieve all columns from one row based on the primary key:

 

DML - SQL Statement to update two fields of one row based on the primary key:

 

DML - SQL Statement to delete one row based on the primary key: