A Subquery that returns exactly one value, so it can be compared like a number.
sql
WHERE rental_rate > (SELECT AVG(rental_rate) FROM film)
When to use
Used in PS 04 (nested queries on Sakila), typically in WHERE to compare against an aggregate such as the average rental rate.
See PS 04.