Indicate the problem with the query which attempts to calculate the average GDP in all years where the GPDwas over10trillion

Question

SELECT AVG(gdp_amount) FROM gdp WHERE year IN (SELECT year FROM gdp WHERE gdp_amount >100 00 ORDER BY YEAR)

I will put choices in the comments

Answer 1

10000 is not 10 trillion. And this ordering by year is completely useless. But doesn't matter, because the sub-select itself is useless. What's your question about this?