Клиенты с платежами, каждый по одному разу

Question

Какие из этих запросов выводят каждого клиента, у которого есть хотя бы один платёж, ровно один раз, без DISTINCT? Выберите все подходящие.

Answer 1

SELECT c.customer_id, c.last_name FROM customer AS c WHERE c.customer_id IN (SELECT p.customer_id FROM payment AS p);

Answer 2

SELECT c.customer_id, c.last_name FROM customer AS c JOIN payment AS p ON p.customer_id = c.customer_id;

Answer 3

SELECT c.customer_id, c.last_name FROM customer AS c CROSS JOIN payment AS p WHERE p.customer_id = c.customer_id;

Answer 4

SELECT c.customer_id, c.last_name FROM customer AS c WHERE EXISTS (SELECT 1 FROM payment AS p WHERE p.customer_id = c.customer_id);

Answer 5

SELECT c.customer_id, c.last_name FROM customer AS c LEFT JOIN payment AS p ON p.customer_id = c.customer_id WHERE p.payment_id IS NOT NULL;

Answer 6

SELECT c.customer_id, c.last_name FROM customer AS c JOIN payment AS p ON p.customer_id = c.customer_id GROUP BY c.customer_id, c.last_name;

Практика