-- Q1: What is a CASE WHEN statement in SQL? Explain its purpose. -- Q2: What is the syntax of a simple CASE statement? -- Q3: Explain the difference between simple CASE and searched CASE. -- Q10: ...

CREATE TABLE Athlete (athlete_id INTEGER PRIMARY KEY, name TEXT NOT NULL); CREATE TABLE Tournament (tournament_id INTEGER PRIMARY KEY, athlete_id INTEGER, name TEXT NOT NULL); CREATE TABLE Format ...