Reading performance & plans
Exercise · SQL & Querying

Predict, then run it

Predict the output

sightings(name, bright) has 5 rows. The three brightest — an ORDER-BY-LIMIT the optimizer can turn into a bounded TOP_N:

SELECT name FROM sightings ORDER BY bright DESC LIMIT 3;

Predict the exact output.