Chapter 1
SELECT queries 101
Card 1 of 8
Idea
A table is a grid
A database table is a grid, like a spreadsheet. Down the side are rows — one per film. Across the top are columns — title, year, rating. That's the whole picture, and everything in this course is a way of asking for part of that grid.
0 of 3 solved
Exercise 1 of 3
Show every column of every film.
Drag blocks here, or tap them below.
Warming up SQLite…
Exercise 2 of 3
Show only the title and year of every film.
Drag blocks here, or tap them below.
Warming up SQLite…
Exercise 3 of 3
Show the title, subgenre and IMDb rating of every film.
Drag blocks here, or tap them below.
Warming up SQLite…