The Canadian sales team works only through the view ca_customers. It shows the customers whose country is CA. Open its tab to see the columns.
Make every change in tasks 1, 2, 5 and 6 through ca_customers, not through customers.
- Liam Patel moved. Set his
citytoToronto. - Add customer 13:
Zoe Park,zoe.p@example.com, countryUS, cityBoston, signup date2025-06-01. - Think before you run it: how many rows does
ca_customersshow now? - Replace the view so that it refuses rows it cannot show. Keep the same columns and the same
WHERE. - Try to add customer 14 from the
USthrough the view. Read the error. - Add customer 14 as a Canadian:
Ethan Roy,ethan.r@example.com, countryCA, cityKingston, signup date2025-06-02.