You have an unknown or unknowable data value (such as the maximum entry in the table) that you need for mathematical manipulation or for comparison purposes. Which SQL structure provides the most likely solution?
Answer – Subquery
(Subquerys execute first. The results (such as an average, maximum, or minimum) can be used by the outer query to deliver data referenced to the inner query.)