CONSULTA MYSQL

select year , count(year) as cantidad from races group by year order by cantidad desc limit 1

RESPUESTA API -

en el año 2021, se dio 23 carreras

CONSULTA MYSQL

SELECT MAX(GAN.DRIVER) AS ' CARRERAS GANADAS', GAN.DRIVERID AS PILOTO, D.NAME AS NOMBRE FROM (SELECT DRIVERID, COUNT(DRIVERID) AS DRIVER FROM RESULTS WHERE POSITIONORDER='1' GROUP BY DRIVERID) GAN JOIN DRIVERS D ON (GAN.DRIVERID=D.DRIVERID);

RESPUESTA API -

EL PILOTO LEWIS HAMILTON , TUVO 95 PRIMEROS PUESTOS

CONSULTA MYSQL

SELECT count(r.circuitId) as cantidad , c.name FROM races r inner JOIN circuits c ON c.circuitId = r.circuitId group by r.circuitId order by cantidad desc limit 1

RESPUESTA API -

EL CIRCUITO Autodromo Nazionale di Monza TIENE 71 RECORRIDOS

CONSULTA MYSQL

(select r.driverId,sum(r.points) as sumapuntos , d.name , c.nationality from results r inner join drivers d on r.driverId=d.driverId inner join constructor c on r.constructorId=c.constructorId where c.nationality="American" group by r.driverId limit 1 ) union all (select r.driverId,sum(r.points) as sumapuntos , d.name , c.nationality from results r inner join drivers d on r.driverId=d.driverId inner join constructor c on r.constructorId=c.constructorId where c.nationality="British" group by r.driverId limit 1 );

RESPUESTA API -

-- el piloto "154 - Romain Grosjean con 104 puntos "cuyo constructor es de nacionalidad American

-- el piloto "1 - Lewis Hamilton British con 913 puntos "cuyo constructor es de nacionalidad British

heroku -- API PREGUNTA1

heroku -- API PREGUNTA2

heroku -- API PREGUNTA3

heroku -- API PREGUNTA4