Select the problem with this query

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

You appear to just be pasting quiz questions from another class or website. If you would like help with something you’re working on, feel free to ask questions, but please do not continue to paste these questions on the forum.