Create a script like the CreateCompanyPG.sql file to create 3 or more tables and populate the tables. You may find it more convenient to break this up into a creation script to create the tables and a population script to fill the tables with data.

Insert data -- insert records for each table. Considering the queries below, make sure to enter enough data to check if your queries are correct. Your data should be from the website when available, but in some cases (like customers or orders), you may need to make up data.

QUERIES -- one basic, one using aggregate operations (AVG, MIN, COUNT, ) , one using at least one subquery (either nested or set operation, like EXCEPT, WHERE IN, WHERE =). The queries should be in a separate file to make it easier to execute them separately from the creation/population statements.