SQL Exercise 2

Average time to complete: 4-6 hours

Instructions

This exercise consists of a set of 10 SQL problems that you will solve using the same online system as exercise 1. It is worth 80 points.

Access the SQL Exercise System here

After our lecture on joins and reviewing the Joins module in the SQL tutorial, you should be able to solve the following questions: 1, 2, 3, 4, 7, 8, and 10.

Permissible Help

Be careful about the help you receive on this assignment. You may not use AI tools to write or debug queries. You may ask other students questions to help you understand the problems and to review relevant material we have discussed in class, but you must write the queries on your own.

You may ask AI tools generic questions like:

• Show me how to use the MAX function in SQL
• Explain how GROUP BY works in SQL
• Show tutorials demonstrating how COUNT works

Deadline

The deadline for this assignment will be announced in Teams.