Skip to main content

Driver Standings

[dbo.driverStandings]

Column nameKeyData typeAllow NULLsDefaultDescription
driverStandingsIdPrimary KeyINT
raceIdFK_DriverStandings_RaceID (dbo.races raceId)INT0Foreign key link to races table
driverIdFK_DriverStandings_DriverID (dbo.drivers driverId)INT0Foreign key link to drivers table
pointsFLOAT0Driver points for season
positionINTDriver standings position (integer)
winsINT0Driver standings position (string)
positionTextIDFK_DriverStandings_PositionTextID (dbo.positionText positionTextID)INTDriver standings position (string)

Table Relationships

Driver Standings

Where Used

Where is this table referenced and what columns are used? The below table shows that information.

Example Query

SELECT 
r.[raceId]
,r.name AS [race_name]
,d.[driverId]
,CONCAT(d.forename, ' ',d.surname) AS [driver_name]
,[points]
,[position]
,[positionText]
,[wins]
FROM
[dbo].[driverStandings] ds

INNER JOIN [dbo].[races] r
ON r.raceId = ds.raceId

INNER JOIN [dbo].[drivers] d
ON d.driverId = ds.driverId
WHERE
r.year = '2023'
AND d.driverId = 1

Example Output

driverStandingsIdraceIddriverIdpointspositionwinspositionTextID
118110111
21828202