1)

SELECT *
  FROM users;

2)

SELECT *
  FROM users
ORDER BY last_name ASC;

3)

SELECT first_name, last_name, registration_date
  FROM users
ORDER BY registration_date DESC
LIMIT 1;

4)

SELECT first_name, last_name, birthdate
  FROM users
WHERE MONTH(birthdate) = MONTH(CURRENT_TIMESTAMP);

5)

SELECT count(id) as 'NbUsers'
  FROM users;

6)

SELECT *
  FROM users
INNER JOIN addresses
ON users.address_id = addresses.id;

7)

SELECT *
  FROM users
INNER JOIN addresses
ON users.address_id = addresses.id
WHERE addresses.number IS NULL;

8)

SELECT *
  FROM products
WHERE price > 1000;

9) 

SELECT *
  FROM products
INNER JOIN pictures
ON pictures.product_id = products.id;

10)

SELECT *
  FROM products
INNER JOIN products_categories ON products_categories.product_id = products.id
INNER JOIN categories ON products_categories.category_id = categories.id
WHERE categories.title = 'Voyage';

11)

SELECT first_name, last_name
  FROM users
INNER JOIN orders ON orders.user_id = users.id
GROUP BY users.id
HAVING COUNT(orders.id) > 10;

12)

SELECT products.name
  FROM products
	INNER JOIN products_orders ON products.id = products_orders.product_id
    INNER JOIN orders ON products_orders.order_id = orders.id
    INNER JOIN users ON orders.user_id = users.id
WHERE users.registration_date IN (
    SELECT MIN(users.registration_date) FROM users)
;
