SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE DriversXL (
  "DriverId" INTEGER,
  "DriverRef" VARCHAR(6),
  "DriverNumber" INTEGER
);

INSERT INTO DriversXL
  ("DriverId", "DriverRef", "DriverNumber")
VALUES
  ('1', 'Lewis', '22'),
  ('2', 'Alonso', '14'),
  ('3', 'Max', '1');

CREATE TABLE races (
  "RaceID" INTEGER,
  "year" INTEGER,
  "CircuitID" INTEGER,
  "Name" VARCHAR(14)
);

INSERT INTO races
  ("RaceID", "year", "CircuitID", "Name")
VALUES
  ('12', '2009', '1', 'Monza'),
  ('13', '2013', '2', 'Bahrain Sakhir');

CREATE TABLE results (
  "ResultID" INTEGER,
  "RaceID" INTEGER,
  "DriverID" INTEGER,
  "Number" INTEGER,
  "Position" INTEGER,
  "Laps" INTEGER
);

INSERT INTO results
  ("ResultID", "RaceID", "DriverID", "Number", "Position", "Laps")
VALUES
  ('1', '12', '1', '22', '1', '53'),
  ('1', '12', '2', '14', '6', '53'),
  ('1', '12', '3', '1', '2', '53'),
  ('2', '13', '1', '22', '2', '57'),
  ('2', '13', '2', '14', '6', '57'),
  ('2', '13', '3', '1', '1', '57');

CREATE TABLE pit_stops (
  "RaceID" INTEGER,
  "DriverID" INTEGER,
  "Stop" INTEGER,
  "Lap" INTEGER
);

INSERT INTO pit_stops
  ("RaceID", "DriverID", "Stop", "Lap")
VALUES
  ('12', '1', '1', '17'),
  ('12', '1', '2', '34'),
  ('12', '2', '1', '14'),
  ('12', '2', '2', '42'),
  ('12', '3', '1', '20'),
  ('12', '3', '2', '37'),
  ('13', '1', '1', '14'),
  ('13', '1', '2', '32'),
  ('13', '2', '1', '12'),
  ('13', '2', '2', '34'),
  ('13', '3', '1', '20'),
  ('13', '3', '2', '42');

23 rows affected

year	name	driverref	stop	lap	position
2009	Monza	Lewis	1	17	1
2009	Monza	Lewis	2	34	1
2013	Bahrain Sakhir	Max	1	20	1
2013	Bahrain Sakhir	Max	2	42	1