1) SELECT name FROM circuits WHERE location = 'Barcelona';

2) SELECT name FROM constructors WHERE nationality = 'Japanese';

3) SELECT name FROM circuits WHERE country='France' ORDER BY lat DESC;

4) SELECT country, count(*) AS nb FROM circuits 
	GROUP BY country HAVING nb > 1
	ORDER BY nb DESC;
	
5) SELECT forename, surname, dob FROM drivers 
	WHERE dob = (SELECT max(dob) FROM drivers);
	
6) SELECT round, name FROM races WHERE year = 1966 ORDER BY round ASC;

7) SELECT count(*) FROM results 
	JOIN drivers ON drivers.driverId = results.driverId
	WHERE forename = 'Ayrton' and surname = 'Senna' and grid = 1;
	
8) SELECT sum(points) FROM results 
	JOIN races ON races.raceId = results.raceId
	JOIN drivers ON drivers.driverId = results.driverId
	WHERE forename = 'Ayrton' and surname = 'Senna' and year = 1985;

9) SELECT circuits.name FROM circuits 
	JOIN races ON circuits.circuitId = races.circuitId
	WHERE races.name = 'French Grand Prix' and year = 1967;

10) SELECT circuits.name, count(*) AS nb FROM circuits 
	JOIN races ON circuits.circuitId = races.circuitId 
	WHERE races.name = 'British Grand Prix'
	GROUP BY circuits.name 
	ORDER BY nb DESC;

11) SELECT date, circuits.name FROM races 
	JOIN circuits ON races.circuitId = circuits.circuitId
	WHERE races.name = 'Brazilian Grand Prix' 
	ORDER BY date ASC LIMIT 1;

12) SELECT name FROM constructors 
	WHERE constructorId IN
	(SELECT constructorId FROM results 
		JOIN drivers ON drivers.constructorId = results.constructorId
		WHERE forename = 'Alain' and surname = 'Prost'
	);

13) SELECT name FROM races 
	WHERE raceId in 
		(SELECT raceId FROM results JOIN drivers.driverId = results.driverId
		WHERE forename = 'Didier' and surname = 'Pironi' and position = 1
		);

14) SELECT forename, surname, name, year FROM results 
	JOIN drivers ON drivers.driverId = results.driverId
	JOIN races ON races.raceId = results.raceId
	WHERE position = 1 AND grid = 
		(SELECT MAX(grid) FROM results WHERE position = 1);

15) SELECT forename, surname, name, date FROM results 
	JOIN races ON races.raceId = results.raceId
	JOIN drivers ON drivers.driverId = results.driverId
	WHERE position = 1 and month(date) = month (dob) and day(date) = day(dob);

16) SELECT forename, surname, sum(points) AS total FROM results 
	JOIN drivers ON drivers.driverId = results.driverId
	JOIN races ON races.raceId = results.raceId
	WHERE year = 1976 
	GROUP BY driverId 
	ORDER BY total 
	DESC LIMIT 3;

17) SELECT constructors.name, sum(points) AS total FROM results 
	JOIN races ON races.raceId = results.raceId
	JOIN constructors ON results.constructorId = constructors.constructorId
	WHERE year = 2001 
	GROUP BY constructors.constructorId 
	ORDER BY total DESC;

18) SELECT d1.surname, d2.surname, d1.dob FROM drivers AS d1 
	JOIN drivers AS d2 ON d1.dob = d2.dob 
	WHERE d1.surname < d2.surname 
	ORDER BY d1.dob ASC