Добавил:
itan_hunt
Опубликованный материал нарушает ваши авторские права? Сообщите нам.
Вуз:
Предмет:
Файл:q11
.sql SELECT
source.name AS source_name
FROM source
LEFT JOIN client
ON client.source_id = source.id
LEFT JOIN sale
ON sale.client_id = client.id
LEFT JOIN status
ON sale.status_id = status.id
WHERE
status.id IS NULL
OR
status.name = 'rejected'
GROUP BY source.id;
source.name AS source_name
FROM source
LEFT JOIN client
ON client.source_id = source.id
LEFT JOIN sale
ON sale.client_id = client.id
LEFT JOIN status
ON sale.status_id = status.id
WHERE
status.id IS NULL
OR
status.name = 'rejected'
GROUP BY source.id;