1. SELECT * FROM users

2. SELECT * FROM users ORDER BY last_name

3. SELECT last_name FROM users ORDER BY registration_date DESC LIMIT 1

4. SELECT * FROM users WHERE birthdate LIKE '%-07-%'

5. SELECT COUNT(*) FROM users

6. SELECT users.last_name, addresses.city
   FROM users JOIN addresses 
   ON users.address_id = addresses.id
   
7. SELECT users.last_name, addresses.number 
   FROM users JOIN addresses 
   ON users.address_id = addresses.id 
   WHERE addresses.number IS NULL

8. SELECT * FROM products WHERE price > 1000

9. SELECT products.name, pictures.caption
   FROM products JOIN pictures
   ON products.id = pictures.product_id
  
10. SELECT products.name, categories.title
    FROM products 
    JOIN products_categories
    ON products.id = products_categories.product_id
    JOIN categories
    ON categories.id = products_categories.category_id
    WHERE categories.title = 'Voyage'
    
11. SELECT users.first_name, COUNT(*) AS total_commandes
    FROM users
    JOIN orders ON users.id = orders.user_id
    GROUP BY users.id
    HAVING COUNT(*) > 10;
    
12. // Ne fonctionne pas
    SELECT orders.reference
    FROM orders
    JOIN users 
    ON orders.user_id = users.id
    JOIN products_orders 
    ON orders.id = products_orders.order_id
    JOIN products
    ON products_orders.order_id = products.id
    WHERE users.id = (SELECT MIN(id) FROM users)
    
    // Ne me retourne aucune ligne
    SELECT orders.reference
    FROM orders
    JOIN users ON orders.user_id = users.id
    JOIN products_orders ON orders.id = products_orders.order_id
    JOIN products ON products_orders.product_id = products.id
    WHERE users.id = (SELECT MIN(id) FROM users)
    
    SELECT users.last_name, users.first_name, products.name
    FROM orders
    JOIN users
    ON orders.user_id = users.id
    JOIN products_orders
    ON orders.id = products_orders.order_id
    JOIN products
    ON products_orders.product_id = products.id
    WHERE users.id = (SELECT MIN(id) FROM users)
    WHERE users.registration_date = (SELECT MIN(registration_date) FROM users)