Subqueries

Due: 11:00pm, Monday, November 14, 2022

Overview

Download the project7.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 project7.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 project7.out:

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

Submission

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

Grading criteria

Style: a query must have the start of each clause at the beginning of a new line.

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