Indicate the problem with the following query which attempts to calculate the average GDP in all years where the GDP was over $10 trillion.
SELECT
AVG(gdp_amount) FROM gdp
WHERE
year IN (SELECT year FROM gdp WHERE gdp_amount > 10000 ORDER BY year)
- The subquery is incorrectly enclosed in parentheses
- The query is missing a GROUP BY clause
- It is invalid to have an ORDER BY clause in a subquery
- The subquery is missing an alias