---

\dt
SELECT count(*) FROM brands;
SELECT count(*) FROM owners;
SELECT count(*) FROM cars;

-- связь трёх таблиц
SELECT c.model, b.brand_name, b.country, o.last_name, o.first_name, c.year, c.price
FROM cars c
JOIN brands b ON c.brand_id = b.brand_id
JOIN owners o ON c.owner_id = o.owner_id
ORDER BY c.price DESC;

-- владельцы на «А» + немецкие марки (тип запроса «с ходу» у препода)
SELECT o.last_name, o.first_name, b.brand_name, c.model
FROM cars c
JOIN owners o ON c.owner_id = o.owner_id
JOIN brands b ON c.brand_id = b.brand_id
WHERE o.last_name LIKE 'А%' AND b.country = 'Германия';