Testing create query: CREATE TABLE cricket_partnerships (
id INT PRIMARY KEY,
player1 VARCHAR(50),
player2 VARCHAR(50),
venue VARCHAR(100),
match_date DATE
);
Testing select query: SELECT venue FROM cricket_partnerships WHERE player1 = 'Shoaib Malik' AND player2 = 'Misbah-ul-Haq' OR player1 = 'Misbah-ul-Haq' AND player2 = 'Shoaib Malik';
[]
Testing create query: CREATE TABLE CricketPartnerships (
id INT PRIMARY KEY,
player1 VARCHAR(255),
player2 VARCHAR(255),
venue VARCHAR(255),
date DATE,
runs_scored INT
);
Testing select query: SELECT venue FROM CricketPartnerships WHERE player1 = 'Herschelle Gibbs' AND player2 = 'Justin Kemp';
[]
Testing create query: CREATE TABLE PointsTable (
NumberPlayed INT,
Points INT
);
Testing select query: SELECT NumberPlayed FROM PointsTable WHERE Points = 310;
[]
Testing create query: CREATE TABLE sports_stats (
team_id INTEGER PRIMARY KEY,
team_name TEXT,
points_against INTEGER,
losing_bonus INTEGER
);
Testing select query: SELECT losing_bonus FROM sports_stats WHERE points_against = 588;
[]
Testing create query: CREATE TABLE rugby_points (
id SERIAL PRIMARY KEY,
team_name VARCHAR(100),
tries_against INT,
losing_bonus INT
);
Testing select query: SELECT * FROM rugby_points WHERE tries_against = 7 AND losing_bonus > 0;
[]
Testing create query: CREATE TABLE rugby_stats (
team_name VARCHAR(50),
games_played INT,
tries_scored INT,
try_bonus INT,
points_against INT
);
Testing select query: SELECT try_bonus FROM rugby_stats WHERE points_against = 488;
[]
Testing create query: CREATE TABLE Points (
id INT PRIMARY KEY,
description VARCHAR(255),
try_bonus INT
);
Testing select query: SELECT * FROM Points WHERE try_bonus = 140;
[]
Testing create query: CREATE TABLE Matches (
MatchID INT PRIMARY KEY,
TeamName VARCHAR(255),
Drawn INT,
TriesAgainst INT
);
Testing select query: SELECT TeamName FROM Matches WHERE Drawn = 1 AND TriesAgainst = 0;
[]
Testing create query: CREATE TABLE Champions (id INT PRIMARY KEY, name VARCHAR(100), reign_days INT, defenses INT);
Testing select query: SELECT reign_days FROM Champions WHERE reign_days > 3 AND defenses = 1;
[]
Testing create query: CREATE TABLE champions (
id INTEGER PRIMARY KEY,
name VARCHAR(255),
reign_days INTEGER,
defenses INTEGER
);
Testing select query: SELECT reign_days FROM champions WHERE reign_days > 3 AND defenses < 1;
[]
Testing create query: CREATE TABLE ChampionReigns (
id INT PRIMARY KEY,
champion_name VARCHAR(255) NOT NULL,
total_defenses INT NOT NULL,
days_held INT NOT NULL
);
Testing select query: SELECT AVG(total_defenses) AS average_defenses
FROM ChampionReigns
WHERE days_held = 404 AND TOTAL_REIGNS > 1;
Error while executing select query: no such column: TOTAL_REIGNS
Testing create query: CREATE TABLE Champions (
id INT PRIMARY KEY,
name VARCHAR(255),
days_held INT,
defense INT
);
Testing select query: SELECT MIN(defense) as lowest_defense FROM Champions WHERE days_held = 345;
[(None,)]
Testing create query: CREATE TABLE games_records (
id INTEGER PRIMARY KEY AUTOINCREMENT,
game_date DATE NOT NULL,
team1_score INTEGER NOT NULL,
team2_score INTEGER NOT NULL
);
Testing select query: SELECT game_date FROM games_records WHERE team1_score = 76 AND team2_score = 72;
[]
Testing create query: CREATE TABLE GameResults (
game_id INT PRIMARY KEY,
pitcher_name VARCHAR(50),
pitcher_record VARCHAR(10),
attendance INT,
result VARCHAR(50)
);
Testing select query: SELECT attendance FROM GameResults WHERE pitcher_name = 'Ponson' AND pitcher_record = '1-5' AND result LIKE '%loss%';
[]
Testing create query: CREATE TABLE records (
id SERIAL PRIMARY KEY,
event_date DATE NOT NULL,
record_type TEXT NOT NULL,
record_value TEXT NOT NULL
);
Testing select query: SELECT event_date FROM records WHERE record_value = '36-39';
[]
Testing create query: CREATE TABLE records (
record_id INT PRIMARY KEY,
win_count INT,
loss_count INT,
record_date DATE
);
Testing select query: SELECT record_date FROM records WHERE win_count = 30 AND loss_count = 31;
[]
Testing create query: CREATE TABLE games (
id INT PRIMARY KEY,
player_name VARCHAR(255),
opponent_name VARCHAR(255),
player_score INT,
opponent_score INT
);
Testing select query: SELECT opponent_name FROM games WHERE player_name = 'Leonard' AND player_score = 7 AND opponent_score = 8;
[]
Testing create query: CREATE TABLE GameScores (
id INT PRIMARY KEY,
record VARCHAR(10),
score VARCHAR(10),
date_played DATE
);
Testing select query: SELECT score FROM GameScores WHERE record = '18–43';
[]
Testing create query: CREATE TABLE game_scores (
id INT PRIMARY KEY AUTO_INCREMENT,
game_date DATE,
opposing_team VARCHAR(50),
team_score INT,
opponent_score INT,
season_record VARCHAR(10)
);
Error while creating the SQLite table: near "AUTO_INCREMENT": syntax error
Testing select query: SELECT team_score, opponent_score FROM game_scores WHERE opposing_team = 'Royals' AND season_record = '24-52';
Error while executing select query: no such table: game_scores
Testing create query: CREATE TABLE GameRecord (
id INT PRIMARY KEY,
record VARCHAR(10),
score VARCHAR(50),
date DATE
);
Testing select query: SELECT score FROM GameRecord WHERE record = '22–46';
[]
Testing create query: CREATE TABLE MilitaryPersonnel (
id INT PRIMARY KEY,
real_name VARCHAR(255),
primary_specialty VARCHAR(255)
);
Testing select query: SELECT real_name FROM MilitaryPersonnel WHERE primary_specialty = 'shock paratrooper';
[]
Testing create query: CREATE TABLE Persons (
PersonID INT PRIMARY KEY,
FirstName VARCHAR(255) NOT NULL,
LastName VARCHAR(255) NOT NULL,
Birthplace VARCHAR(255) NOT NULL
);
Testing select query: SELECT Birthplace FROM Persons WHERE FirstName = 'Pete' AND LastName = 'Sanderson';
[]
Testing create query: CREATE TABLE roles (
id SERIAL PRIMARY KEY,
person_name VARCHAR(100) NOT NULL,
role_title VARCHAR(100) NOT NULL
);
Testing select query: SELECT role_title FROM roles WHERE person_name = 'Jean-Luc Bouvier';
[]
Testing create query: CREATE TABLE KayakPilots (
id INT PRIMARY KEY,
real_name VARCHAR(255),
nickname VARCHAR(255),
vessel_type VARCHAR(100)
);
Testing select query: SELECT real_name FROM KayakPilots WHERE vessel_type = 'silent attack kayak';
[]
Testing create query: CREATE TABLE people (
id INT PRIMARY KEY,
name VARCHAR(100),
code_name VARCHAR(100),
city_of_birth VARCHAR(100),
date_of_birth DATE
);
Testing select query: SELECT code_name FROM people WHERE city_of_birth = 'Liverpool';
[]
Testing create query: CREATE TABLE CanoeingMedalists (
id INT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
event VARCHAR(100) NOT NULL,
medal_type VARCHAR(50) NOT NULL,
year INT NOT NULL
);
Testing select query: SELECT name FROM CanoeingMedalists WHERE event = 'Canoeing';
[]
Testing create query: CREATE TABLE HalfMiddleweightEvents (
GameID INT PRIMARY KEY,
GameName VARCHAR(255),
Event VARCHAR(50),
Year INT
);
Testing select query: SELECT GameName, Year FROM HalfMiddleweightEvents WHERE Event = 'Women\'s Half Middleweight';
Error while executing select query: near "s": syntax error
Testing create query: CREATE TABLE OlympicMedalists2000 (
AthleteID INT PRIMARY KEY,
Name VARCHAR(255) NOT NULL,
MedalType VARCHAR(50) NOT NULL,
Event VARCHAR(255) NOT NULL,
Country VARCHAR(100) NOT NULL
);
Testing select query: SELECT Name, Event, Country FROM OlympicMedalists2000 WHERE MedalType = 'Bronze' AND Event = 'Specific Event Name';
[]
Testing create query: CREATE TABLE GameAttendance (
GameID INT PRIMARY KEY,
Opponent VARCHAR(50),
Attendance INT
);
Testing select query: SELECT SUM(Attendance) AS Total_Attendance
FROM GameAttendance
WHERE Opponent = 'Twins';
[(None,)]
Testing create query: CREATE TABLE sports_records (
id SERIAL PRIMARY KEY,
date DATE NOT NULL,
record VARCHAR(255) NOT NULL
);
Testing select query: SELECT date FROM sports_records WHERE record = '41-46';
[]
Testing create query: CREATE TABLE Scores (
id INT PRIMARY KEY,
score_name VARCHAR(255),
score_value VARCHAR(10)
);
Testing select query: SELECT score_name FROM Scores WHERE score_value = '48-55';
[]
Testing create query: CREATE TABLE sports_records (
team_name VARCHAR(255),
games_won INT,
games_lost INT,
PRIMARY KEY (team_name)
);
Testing select query: SELECT team_name FROM sports_records WHERE games_won = 44 AND games_lost = 49;
[]
Testing create query: CREATE TABLE games (
game_id INT PRIMARY KEY,
opponent VARCHAR(50),
record VARCHAR(10),
score VARCHAR(10)
);
Testing select query: SELECT score FROM games WHERE opponent = 'white sox' AND record = '2-0';
[]
Testing create query: CREATE TABLE election_votes (
candidate_name VARCHAR(255),
votes_received INT
);
Testing select query: SELECT votes_received FROM election_votes WHERE candidate_name = 'Candice Sjostrom';
[]
Testing create query: CREATE TABLE election_results (
candidate_name VARCHAR(100),
votes_received INT,
total_votes INT
);
Testing select query: SELECT (votes_received * 100.0) / total_votes AS percentage_received
FROM election_results
WHERE candidate_name = 'Chris Wright';
[]
Testing create query: CREATE TABLE election_results (
election_year INT,
candidate_name VARCHAR(255),
vote_count INT,
vote_percentage DECIMAL(5, 2),
office VARCHAR(255),
office_district INT
);
Testing select query: SELECT vote_count
FROM election_results
WHERE election_year > 1992
AND vote_percentage = 1.59
AND office = 'us representative'
AND office_district = 4;
[]
Testing create query: CREATE TABLE Representatives (
id SERIAL PRIMARY KEY,
first_name VARCHAR(50),
last_name VARCHAR(50),
start_year INT,
end_year INT
);
Testing select query: SELECT start_year, end_year FROM Representatives WHERE first_name = 'J.' AND last_name = 'Smith Young';
[]
Testing create query: CREATE TABLE Politicians (
id INT PRIMARY KEY,
name VARCHAR(100),
party VARCHAR(100)
);
Testing select query: SELECT party FROM Politicians WHERE name = 'Thomas L. Young';
[]
Testing create query: CREATE TABLE MedalCounts (
Country VARCHAR(100),
Gold INT,
Silver INT,
Bronze INT,
Total INT
);
Testing select query: SELECT MIN(Total) AS LowestMedalCount FROM MedalCounts
WHERE Gold = 0 AND Bronze > 2 AND Silver > 1;
[(None,)]
Testing create query: CREATE TABLE country_medals (
rank INT,
country_name VARCHAR(255),
gold_medals INT,
silver_medals INT,
bronze_medals INT,
total_medals INT
);
Testing select query: SELECT SUM(silver_medals) FROM country_medals WHERE rank = 14 AND total_medals < 1;
[(None,)]
Testing create query: CREATE TABLE player_stats (
player_id INT PRIMARY KEY,
player_name VARCHAR(100),
tackles INT,
fumble_recoveries INT,
forced_fumbles INT
);
Testing select query: SELECT tackles FROM player_stats WHERE fumble_recoveries > 0 AND forced_fumbles > 0;
[]
Testing create query: CREATE TABLE DefensiveStats (
player_id INT PRIMARY KEY,
player_name VARCHAR(100),
solo_tackles INT,
forced_fumbles INT
);
Testing select query: SELECT forced_fumbles FROM DefensiveStats WHERE player_name = 'jim laney' AND solo_tackles < 2;
[]
Testing create query: CREATE TABLE PlayersStats (
PlayerID INT PRIMARY KEY,
PlayerName VARCHAR(255),
SoloTackles INT,
Total INT
);
Testing select query: SELECT MAX(Total) AS HighTotal FROM PlayersStats WHERE SoloTackles > 15;
[(None,)]
Testing create query: CREATE TABLE PlayerStats (
player_id INT PRIMARY KEY,
player_name VARCHAR(100),
fumble_recoveries INT,
forced_fumbles INT,
sacks INT,
solo_tackles INT
);
Testing select query: SELECT fumble_recoveries FROM PlayerStats WHERE player_name = 'Scott Gajos' AND forced_fumbles = 0 AND sacks = 0 AND solo_tackles < 2;
[]
Testing create query: CREATE TABLE Matches (
MatchID INT PRIMARY KEY,
HomeTeam VARCHAR(255),
OpponentTeam VARCHAR(255),
MatchTime TIME,
Stadium VARCHAR(255)
);
Testing select query: SELECT OpponentTeam FROM Matches WHERE MatchTime = '20:00:00' AND Stadium = 'Camp Nou';
[]
Testing create query: CREATE TABLE matches (
id INT PRIMARY KEY,
date DATE,
time TIME,
score VARCHAR(5)
);
Testing select query: SELECT time FROM matches WHERE score = '3-2';
[]
Testing create query: CREATE TABLE Matches (
MatchID INT PRIMARY KEY,
HomeTeam VARCHAR(255),
AwayTeam VARCHAR(255),
Ground VARCHAR(255),
MatchDate DATE
);
Testing select query: SELECT Ground FROM Matches WHERE HomeTeam = 'Aston Villa' OR AwayTeam = 'Aston Villa';
[]
Testing create query: CREATE TABLE CompetitionEvents (
EventID INT PRIMARY KEY AUTO_INCREMENT,
CompetitionName VARCHAR(100),
Location VARCHAR(100),
EventTime TIME,
EventDate DATE
);
Error while creating the SQLite table: near "AUTO_INCREMENT": syntax error
Testing select query: SELECT CompetitionName FROM CompetitionEvents
WHERE Location = 'San Siro' AND EventTime = '18:30:00'
ORDER BY EventDate DESC
LIMIT 1;
Error while executing select query: no such table: CompetitionEvents
Testing create query: CREATE TABLE school_locality_deciles (
locality_id INT PRIMARY KEY,
locality_name VARCHAR(255),
total_decile INT
);
Testing select query: SELECT locality_name, total_decile FROM school_locality_deciles WHERE locality_name = 'redwood';
[]
Testing create query: CREATE TABLE racing_reports (
report_id INT PRIMARY KEY,
report_name VARCHAR(255) NOT NULL,
track_name VARCHAR(255),
event_date DATE
);
Testing select query: SELECT report_name FROM racing_reports WHERE track_name = 'Circuit of Tripoli';
[]
