Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLcorrelated subqueriesSingle-choice MCQ

A correlated subquery is used inside the SELECT list. For the row where `o.region` matches no rows in the inner table, what does this return for `latest`?

SELECT o.id, (SELECT MAX(s.amount) FROM sales s WHERE s.region = o.region) AS latest FROM orders o;