1.SELECT * FROM `users`

2.SELECT * FROM `users` ORDER BY `last_name` ASC

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

4.SELECT * FROM `users`
WHERE MONTH(`birthdate`) = MONTH(CURRENT_DATE);

5.SELECT COUNT(*) AS total_users FROM `users`;

6.SELECT u.first_name, u.last_name, a.city
FROM users u
JOIN addresses a ON u.address_id = a.id;

7.SELECT u.first_name, u.last_name, a.street, a.city
FROM users u
JOIN addresses a ON u.address_id = a.id
WHERE a.number IS NULL OR a.number = '';

8.SELECT * FROM `products`
WHERE price > 1000

9.SELECT p.id, p.name, pic.caption
FROM products p
JOIN pictures pic ON pic.product_id = p.id

10.SELECT p.id, p.name, c.title
FROM products p
JOIN products_categories pc ON pc.product_id = p.id
JOIN categories c ON c.id = pc.category_id
WHERE c.title = 'Voyage';

11.SELECT u.id, u.first_name, u.last_name, COUNT(o.id) AS total_orders
FROM users u
JOIN orders o ON o.user_id = u.id
GROUP BY u.id, u.first_name, u.last_name
HAVING COUNT(o.id) > 10;

12.SELECT p.id, p.name, u.first_name, u.last_name
FROM products p
JOIN products_orders po ON po.product_id = p.id
JOIN orders o ON o.id = po.order_id
JOIN users u ON u.id = o.user_id
WHERE u.id = (
    SELECT id
    FROM users
    ORDER BY registration_date ASC
    LIMIT 1
)

part 2

1.SELECT name, description, price
FROM `products`

SELECT name, description, price
FROM `products`
WHERE price < 42
ORDER BY price DESC


3.SELECT city, street, number, postal_code
FROM `addresses`

4.SELECT city, street, number, postal_code
FROM `addresses`
WHERE city LIKE 'A%'

5.SELECT * FROM `users`

6.SELECT * FROM `users`
ORDER BY birthdate

7.SELECT *, TIMESTAMPDIFF(YEAR, birthdate, CURDATE()) AS age
FROM users
WHERE TIMESTAMPDIFF(YEAR, birthdate, CURDATE()) < 50
ORDER BY birthdate ASC

8.SELECT 
  first_name, 
  last_name, 
  birthdate, 
  TIMESTAMPDIFF(YEAR, birthdate, CURDATE()) AS Age
FROM users
WHERE TIMESTAMPDIFF(YEAR, birthdate, CURDATE()) > 50
ORDER BY birthdate ASC;