The Monster Market team needs five lists. Each request needs more than one tool from this chapter. Read each request carefully: some rows are easy to lose, and some are easy to keep by mistake.

1. Members from outside Canada who signed up in the first half of 2024 (1 January to 30 June): name, country, then signup_date.
2. The out-of-stock products in categories 1 and 3, and also every product with no category: name, category_id, then stock.
3. The orders placed from 1 February to 30 April 2025 that are not delivered: id, order_date, then status.
4. The customers that the shop cannot reach by post or by email, because the city or the email is missing: name, city, then email.
5. The employees with Lead or Head in their title who earn more than 70 000: name, title, then salary.