62 подписчика
--Тестовый сценарий-2 (GROUP BY)
WITH random_airplanes AS (
SELECT airplane_code
FROM bookings.airplanes_data
ORDER BY random()
LIMIT (random() * 9 + 1)::int -- От 1 до 10 значений
)
SELECT s.fare_conditions,
COUNT(*) as seat_count,
COUNT(DISTINCT s.airplane_code) as airplane_types
FROM bookings.seats s
WHERE s.airplane_code IN (SELECT airplane_code FROM random_airplanes)
GROUP BY s.fare_conditions
ORDER BY seat_count DESC;
Около минуты
17 декабря