+ 2
Sql - SUBQUERY
Hey buddy. How are you? I have a quick question if you donât mind answering. I am so confused on why this is not showing up in the order of the test. Can someone please Clear up what I am doing wrong? SELECT name,category,price,fatpercentage FROM foods WHERE fatpercentage < (SELECT AVG (fatpercentage) FROM foods) ORDER BY price,category,fatpercentage DESC;
6 Answers
+ 4
Tevin
Just remove ORDER BY
+ 2
Tevin
What did you understand by remove ORDER BY means?
+ 1
All you said was remove ORDER BY. Would you elaberate what you mean by removing ORDER BY?
+ 1
Tevin
Check the task description did they say to get data in order? Did they say to use ORDER BY?
+ 1
I figured it out thanks
0
That gave me a syntax error