Insegnamento
Course full name
Foundations of Computer Science
Course ID number
2021-1-F9101Q001
Exercise: SQL exercise
Completion requirements
Opened: Wednesday, 7 October 2020, 12:00 AM
On the tables of the sample database NorthWind compute:
- The customers with state_province that is one of UT, MN, and WI.
- The customers whose address starts with “456”.
- The customers whose last_name is at least 4 characters long.
- The customers with ID larger than 20.
- The customers that have placed at least an order.
- The customers that have placed at least two orders.
- For each customer, the total amount of taxes paid.
- For each customer, the total amount of taxes paid and of shipping fee (the result must be one table).
The assignment will not be graded.