Each task has more than one condition. Decide which conditions must all be true, and which need only one.

1. The members who live in Canada: name, then city.
2. The members from the US or Canada: name, then country.
3. The products that cost less than 20 and are in stock (stock above 0): name, price, then stock.
4. The orders that are neither delivered nor cancelled: id, then status. Use NOT once.
5. Think before you run it: how many rows does SELECT * FROM products WHERE category_id = 1 OR category_id = 2 AND price > 30; return?