Basic SQL Queries

Due: 11:00pm, Wednesday, September 14, 2022

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

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

Turn in the completed SQL script to the appropriate folder on D2L.