SQL 14.2 Practice Let’s get fit error!!

Question

SELECT * FROM Food
WHERE fatpercentage < (SELECT AVG(fatpercentage) FROM Food);

The result is giving an error that the Food table does not exist. How is this possible as the table name is clearly mentioned in the question. Please assist.

Answer 1

Thanks AJ

Answer 2

problem: Monica has just returned from her nutritionist and was advised to only eat low-fat foods......
...........Select all columns from the table and sort the result by the fatpercentage column in ascending order.

sol. code:

SELECT *FROM Products
WHERE fatpercentage < (SELECT AVG(fatpercentage) FROM Products) order by fatpercentage asc;

Answer 3

soheb masani It's bug.

Answer 4

def a bug

Answer 5

SELECT *FROM Foods
WHERE fatpercentage < (SELECT AVG(fatpercentage) FROM Foods);
Try this

Answer 6

write Foods not food