Skip to content

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…