DISTINCT

Many queries produce duplicate rows. A query that pulls every country from the streams table returns one row per stream, not one row per country, so "US" might appear hundreds of times.

DISTINCT eliminates those duplicates, but it comes with subtleties around multiple columns, ordering, and performance that are worth understanding before you reach for it.