How can i solve sql cakes excrsise.

Answer 1

ARNAV SINGH here is the query

SELECT name, calories
FROM cakes
ORDER BY calories
LIMIT 3;

Answer 2

You can use the InitCap() function. It worked for me.

It’s a workaround until the bugs are squashed😀

https://oraclesql.in/initcap/

Answer 3

SELECT name, calories
FROM cakes
ORDER BY calories ASC
LIMIT 3;

This should work 👍🏼

Answer 4

SELECT * FROM cakes ORDER BY calories LIMIT 3;

Answer 5

Copy this answer correct and like check

Answer 6

SELECT name, calories
FROM cakes
ORDER BY calories ASC
LIMIT 3;

Answer 7

SELECT name, calories
FROM cakes ORDER BY calories LIMIT 3;

Answer 8

simplest way i can just this

select *
from cakes
order by calories
limit 3;

Answer 9

SELECT *
FROM cakes
ORDER BY calories
LIMIT 3;