Clientes con pagos, cada uno una sola vez

Question

¿Cuáles de estas consultas muestran exactamente una vez a cada cliente que tiene al menos un pago, sin DISTINCT? Elige todas las opciones correctas.

Answer 1

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

Answer 2

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 3

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 4

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

Answer 5

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 6

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;

Práctica