Help me in this question please (cake exercise)

Question

A local bakery creates unique cake sets. Each cake set contains three different cakes.
Here is the cakes table:

Тoday a customer want a cake set that has minimal calories.
Write a query to sort the cakes by calorie count and select the first 3 cakes from the list to offer the customer.
Use limit and ORDER by

I answered it :

SELECT name, salary
from calories
ORDER by calories ASC
LIMIT 3 ;

But i do not know why it is wrong

Answer 1

SELECT*FROM Cakes
ORDER BY calories LIMIT 3;

Answer 2

A local bakery creates unique cake sets. Each cake set contains three different cakes.
Тoday a customer want a cake set that has minimal calories.
Write a query to sort the cakes by calorie count and select the first 3 cakes from the list to offer the customer.

Ans:-
SELECT * FROM Cakes ORDER BY Calories LIMIT 3;

Answer 3

SELECT * FROM cakes ORDER BY calories LIMIT 3;

Answer 4

SELECT * FROM cakes
ORDER BY calories LIMIT 3;

Answer 5

SELECT * FROM cakes ORDER BY calories
LIMIT 3 ;

Answer 6

@RUKHSANA PRAVEEN
Can you please tell why ORDER BY is written before LIMIT?

Answer 7

Correct Answer:-

SELECT*FROM Cakes
ORDER BY calories LIMIT 3;

Answer 8

SELECT* FROM Cakes ORDER By calories LIMIT 3 ;

Answer 9

SELECT* FROM Cakes
ORDER By calories
LIMIT 3 ;

Answer 10

Table important give attention!

SELECT name, calories
from cakes
ORDER by calories ASC
LIMIT 3 ;

Answer 11

pasant Hussein

calories is a table name then how it could be use in ORDER BY?

There is table name Cakes not Calories.

SELECT * FROM Cakes ORDER BY Calories LIMIT 3;

Answer 12

Thanks alot 🤍

Answer 13

Select Name,Calories from Cakes order by Calories limit 3;

Answer 14

SELECT* FROM Cakes ORDER By calories LIMIT 3 ;

Answer 15

SELECT * FROM Cakes ORDER BY Calories LIMIT 3;

Answer 16

SELECT* FROM Cakes ORDER By calories LIMIT 3 ;