Qual comando SQL lista todos os quartos que foram reservados...

Qual comando SQL lista todos os quartos que foram reservados mais de uma vez?

a. SELECT descricao FROM quartos WHERE id_quarto IN (SELECT id_quarto FROM reservas_quartos GROUP BY id_quarto HAVING COUNT(id_reserva) > 1);

b. SELECT id_quarto FROM reservas_quartos GROUP BY id_quarto HAVING COUNT(id_reserva) > 1;

c. SELECT descricao FROM quartos JOIN reservas_quartos ON quartos.id_quarto = reservas_quartos.id_quarto GROUP BY quartos.id_quarto HAVING COUNT(quartos.id_quarto) = 1;

d. SELECT descricao FROM quartos JOIN reservas_quartos ON quartos.id_quarto = reservas_quartos.id_quarto WHERE COUNT(reservas_quartos.id_quarto) > 1;