MySQL - Ayuda con consulta SQL

CREATE TABLE mobilitat.reserves

(

  id_reserva serial NOT NULL,

  fk_client integer NOT NULL,

  fk_moto integer NOT NULL,

  data_inici date,

  data_fi date,

  import real,

  CONSTRAINT pkreserves PRIMARY KEY (id_reserva),

  CONSTRAINT fkclient FOREIGN KEY (fk_client)

      REFERENCES mobilitat.clients (id_client) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE,

  CONSTRAINT fkmoto FOREIGN KEY (fk_moto)

      REFERENCES mobilitat.motos (id_moto) MATCH SIMPLE

      ON UPDATE CASCADE ON DELETE CASCADE

);

CREATE TABLE mobilitat.clients

(

  id_client serial NOT NULL,

  dni character varying(10) NOT NULL,

  nom character varying(30) NOT NULL,

  cognoms character varying(60) NOT NULL,

  telefon character varying(15) NOT NULL,

  email character varying(20) NOT NULL,

  CONSTRAINT pkclient PRIMARY KEY (id_client),

  CONSTRAINT clients_dni_key UNIQUE (dni)

);

select id_client, nom, cognoms from clients

where (select count(fk_client) total from reserves

	group by fk_client

	limit 1 ) > 2 ;

select * from clients c

RIGHT JOIN

(select fk_client, count(fk_client) total from reserves group by fk_client) s1

ON c.id_client=s1.fk_client