Find the id, forename and number of races of all drivers who have at least participated in two races?
select t1.driverid, t1.forename, count ( * ) from drivers as t1 join results as t2 on t1.driverid = t2.driverid join races as t3 on t2.raceid = t3.raceid group by t1.driverid having count ( * ) > = 2
Yes
select driverref, nationality from drivers where forename = 'Fernando'
yes
select t2.position, count ( * ) from drivers as t1 join results as t2 on t1.driverid = t2.driverid join races as t3 on t2.raceid = t3.raceid where t1.forename = 'Fernando' and rank = 1