$ ./guess_the_languageSQL & Databases
SQL & Databases · medium · #9

How many rows does this return?

-- sizes has 3 rows, colors has 4 rows
SELECT * FROM sizes
CROSS JOIN colors;
  1. 12
  2. 16
  3. 7
  4. 10
A CROSS JOIN is a Cartesian product: every size pairs with every color, 3 x 4 = 12.
Play SQL & Databases ▸