SQL Challenger
0 of 250 complete

Lessons

0 of 250 complete

Saved in this browser

Lesson 65 of 250

Easy

Keep duplicates with UNION ALL

Your task

Return Indie album titles and titles priced below 20 as one result. Include overlapping titles twice. Order is flexible.

UNION ALL keeps every row, including overlaps between the two inputs.

Sample data

Table:albums
idtitlegenrepricestock
1Night BusJazz187
2Static BloomIndie224
3Soft CircuitElectronic240
4Blue HourJazz163
5CoastlineIndie198
6Low TideAmbient212

Expected output

title
Static Bloom
Coastline
Night Bus
Blue Hour
Coastline
Show a hint

Use UNION ALL without an outer DISTINCT.

Joins and set operations guide

Match rows by a key

A join combines columns horizontally. The condition links sales.album_id to albums.id. If an album has three sale records, a join can return its title three times.

SELECT s.id AS sale_id, a.title, s.quantity
FROM sales AS s
JOIN albums AS a ON a.id = s.album_id;

Preserve rows without a match

A LEFT JOIN retains each album. The quantity condition belongs in ON because it defines which sales qualify as matches. Placing it in WHERE would also remove albums whose sale columns are NULL.

SELECT a.title, s.id AS large_sale_id
FROM albums AS a
LEFT JOIN sales AS s
  ON s.album_id = a.id
 AND s.quantity >= 3;

Combine result sets vertically

UNION stacks compatible result sets and removes duplicate rows. UNION ALL keeps every row. INTERSECT keeps shared rows, and EXCEPT keeps rows unique to the first result. With set operations, both inputs must return the same number of columns.

SELECT title FROM albums WHERE genre = 'Jazz'
UNION
SELECT title FROM albums WHERE price < 20;
SQLiteCtrl / ⌘ + Enter

Press Control+Space for SQL suggestions. Use the arrow keys to select an option and Enter to insert it.

Results

Loading SQLite…