The Monster Market team needs five reports. Each one uses tools from Chapters 1 to 3. Where a task asks for an order, the check compares the order too.
- The 3 members who signed up most recently, newest first:
name, thensignup_date. - A price list of the products that are in stock:
name,price, then a column namedband. The band isbudgetbelow 15,standardbelow 35, andpremiumfor the others. Most expensive first; for equal prices, sort by name. - A mailing list of the customers outside Canada, sorted by name: the name in upper case, then the email, with
unknownwhere the email is missing. - Page 2 of the order list, with 5 orders per page, newest first:
id,order_date, thenstatus. - How many different prices do the products have?