Can anyone help me in SQL 'cake' project.

Question

SELECT *FROM cakes table;
ORDER BY minimal calories;LIMIT 3;

Answer 1

Arvind Kumar , change your query => SELECT * FROM cakes
ORDER BY calories LIMIT 3;

Answer 2

When you input:
SELECT * FROM cakes ORDER BY calories LIMIT 3;

it ouputs:
name,calories
opera cake,90
sponge cake,100
apple cake,100

and calls it wrong, seems like the table lists the cakes with lower case letters?

Answer 3

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

Answer 4

Select InitCap(name) as name, calories from cakes order by calories limit 3

Answer 5

SELECT * FROM cakes ORDER BY calories LIMIT 3;

Answer 6

TheWh¡teCat 🇧🇬 thank you

Answer 7

SELECT * FROM cakes ORDER BY calories LIMIT 3;

write this only

Answer 8

select * from cakes order by calories asc limit 3;

Answer 9

SELECT * FROM cakes ORDER BY calories LIMIT 3;

working

Answer 10

SELECT * FROM CAKES ORDER BY CALORIES LIMIT 3

Answer 11

SELECT * FROM cakes ORDER BY calories LIMIT 3;

Answer 12

it's working now!

Answer 13

SELECT * FROM cakes ORDER BY calories LIMIT 3;

Answer 14

Not working