The following assignment is based on the database environment created

Design and develop the below queries using professional principles and standards:

• A set of SQL Statements that returns all rows and all data for each table in your database.

• Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause.

• Two SQL Statements that join two or more tables in one query. Look for primary and foreign keys to help you determine join points. Use the JOIN clause as a part of your queries.

Submit an .sql file with the scripts needed to create the required queries.