Here is the assignment.
Correction: The first question requires seven SQL statements, not five.
As you’re working through the assignment, if you get an error message like this:
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.
Do the following to fix it:
- Go the Edit menu and select Preferences.
- Select the “SQL Editor Tab”
- Uncheck the “Safe Updates” box
- Close MySQL Workbench and restart the program. This will let you make “unsafe” updates. But be careful!