Clientes com pagamentos, cada um uma só vez

Question

Quais destas consultas listam cada cliente que tem pelo menos um pagamento exatamente uma vez, sem DISTINCT? Escolha todas as opções corretas.

Answer 1

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;

Answer 2

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

Answer 3

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

Answer 4

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 5

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 6

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

Prática