Basic SQL Queries 2

Due: 11:00pm, Monday, September 19, 2022

Download the project2.sql file from D2L. Then copy the file to the CSIT Linux server. This file contains comments describing the queries that you must write. To run the SQL script with the appropriate database, execute the command:

    psql -d sakila -f project2.sql

This will produce output to the terminal. Another option is to direct the output to a file (this is probably easier for debugging purposes.) The following command will direct the output to a file named project2.out:

    psql -d sakila -f project2.sql > project2.out

Turn in the completed SQL script to the appropriate folder on D2L. Do not change the name of the script.

Note: If the code has syntax errors or does not execute properly, you will receive a failing grade for this assignment.