#1

SELECT 
    status
FROM
    orders
GROUP BY status;

#2

SELECT DISTINCT
    status
FROM
    orders;

#3

SELECT 
    status, COUNT(*)
FROM
    orders
GROUP BY status;

#4

SELECT status,
           SUM(quantityOrdered * priceEach) AS amount
FROM orders
INNER JOIN orderdetails
USING (orderNumber)
GROUP BY  status;

#5

SELECT 
    orderNumber,
    SUM(quantityOrdered * priceEach) AS total
FROM
    orderdetails
GROUP BY orderNumber;

#6

SELECT 
    YEAR(orderDate) AS year,
    SUM(quantityOrdered * priceEach) AS total
FROM
    orders
        INNER JOIN
    orderdetails USING (orderNumber)
WHERE
    status = 'Shipped'
GROUP BY YEAR(orderDate);

#7

SELECT 
    YEAR(orderDate) AS year,
    SUM(quantityOrdered * priceEach) AS total
FROM
    orders
        INNER JOIN
    orderdetails USING (orderNumber)
WHERE
    status = 'Shipped'
GROUP BY year
HAVING year > 2003;

#8

SELECT 
    YEAR(orderDate) AS year, COUNT(orderNumber)
FROM
    orders
GROUP BY year;

#9

SELECT 
    status, COUNT(*)
FROM
    orders
GROUP BY status DESC;