SQL Review

Review

How review works

Ideas you missed in a checkpoint come back here a day later, then again a few days after that. A couple of short problems each. Coming back to them after a gap is what makes them stick.

    Back to the course
      problem.sql to run
      SELECT name
FROM students
WHERE club = Drama;
      problem.sql to run
      SELECT name, year
FROM students;
      problem.sql to run
      SELECT name, year
FROM students
WHERE year = 12;
      problem.sql
      SELECT title
FROM songs
WHERE seconds BETWEEN 176 AND 210;
      problem.sql to run
      SELECT title, genre, seconds
FROM songs
WHERE genre = 'pop' OR genre = 'lofi' AND seconds < 200;
      problem.sql to run
      SELECT title, artist
FROM songs
WHERE genre IN ('lofi', 'indie');
      problem.sql
      SELECT gamertag
FROM leaderboard
WHERE level = 37 OR level = 29
ORDER BY score
LIMIT 2;
      problem.sql to run
      SELECT gamertag, level
FROM leaderboard
ORDER BY level;
      problem.sql to run
      SELECT gamertag, score
FROM leaderboard
ORDER BY score DESC
LIMIT 2;
      problem.sql
      SELECT name, stock / 5 AS packs
FROM snacks;
      problem.sql to run
      SELECT * FROM snacks;
      problem.sql to run
      SELECT name
FROM snacks;
      problem.sql
      SELECT DISTINCT title, year
FROM films
WHERE title LIKE 'The L%'
ORDER BY title, year;
      problem.sql to run
      SELECT DISTINCT genre, year
FROM films
ORDER BY genre;
      problem.sql to run
      SELECT age_rating
FROM films;
      SQLite