Search results
13 gru 2019 · Just for example: With DependencedIncidents AS ( SELECT INC.[RecTime],INC.[SQL] AS [str] FROM ( SELECT A.[RecTime] As [RecTime],X.[SQL] As [SQL] FROM [EventView] AS A CROS...
18 gru 2023 · The SQL WITH clause allows you to define a CTE (common table expression). A CTE is like a table that is populated during query execution. You can use multiple WITH statements in one SQL query to define multiple CTEs. In this article, we will explain how to define multiple CTEs in a single query.
-- Analysing Formula 1 data 1950-2020 using dataset from Kaggle -- GENERAL QUERIES SELECT * FROM results; -- Find driver who's competed in the most races (Alonso) SELECT results.driverId, COUNT (results.RaceId), drivers.surname, drivers.forename FROM results JOIN drivers ON results.driverId = drivers.driverId GROUP BY driverId , drivers.s...
F1DB is the most comprehensive free open source database with all-time Formula 1 racing data and statistics. Whether you are building a custom website, mobile application or just using F1DB to query data, here is what we provide: All drivers. All constructors (including chassis) All engine manufacturers (including engines) All tyre manufacturers.
Project based on Formula 1 World Championship (1950 - 2022). The dataset consists of all information on the Formula 1 races, drivers, constructors, qualifying, circuits, lap times, pit stops, championships from 1950 till the latest 2021 season.
Questions. This analysis will try to answer the following questions: Drivers. Which driver had the most F1 World Driver’s Champion title? Which driver had obtained the most pole position? Which driver had the most points throughout their career? How many F1 drivers that actually won at least one race? What are the nationality of most F1 drivers?
Performance Analysis: Using SQL and Tableau, the project delves into various aspects of Formula 1 racing, such as driver performance across seasons, race track statistics, and the impact of rule changes.
