Two new tables are empty: restock_list and newsletter. Open their tabs and read their columns, in order.
- Run the query in the editor. If an INSERT used this SELECT, how many rows would it add?
- Fill
restock_listwith every product that has fewer than 10 units in stock: its id, name and stock. - Copy every member (
is_memberis true) intonewsletter: their email, their name, and the sourcemember. - Also add the customers from Canada (
CA) who are not members, with the sourcecanada.
Each value goes into the column at the same position in your column list. Check the tab after each INSERT.