Help I'm stuck

Question

No matter what i try it always says no output

the challange:
Т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.

my code:
SELECT * FROM cakes
ORDER BY calories LIMIT 3;

Answer 1

The end of module projects are currently broken and not working. Hopefully, SL will resolve the issue soon!

Edit: Since the time of this answer this issue has been long resolved and it is no longer valid. So, you can stop being disgruntled little downvoters and grow up!

Answer 2

Best solution of this code
SELECT * FROM Cakes ORDER BY Calories LIMIT 3;

Answer 3

Same issue here it always shows error please help me

My code
SELECT * FROM cakes ORDER BY calories Limit 3;

Answer 4

select * from cakes -- it will retrieve all the information from the table.(cakes)
order by calories --order by will select to sort and return the data
limit 3 ; --limit is limit .(-- is used as a comments in SQL).

SQL is insensitive so you write a queries in any case(upper,lower).

Answer 5

SELECT * FROM cakes ORDER BY Calories limit 3;

Answer 6

SELECT name FROM cakes ORDER BY Calories LlMIT 3;

Answer 7

SELECT * FROM cakes WHERE calories BETWEEN 90 AND 100
ORDER BY calories ASC
LIMIT 3;

I still have an error, cause the order in this question is strange(((

Also I was tried next:
SELECT * FROM cakes WHERE calories <=100
ORDER BY calories ASC
LIMIT 3;

It's doesn't work too(

Answer 8

SELECT * FROM cakes ORDER BY calories ASC LIMIT 3

working!
ASC - sort result in ascending order.

Answer 9

SELECT name,min(calories) FROM cakes GROUP BY calories LIMIT 3.

***But still not output.

Answer 10

SELECT * FROM cakes
ORDER BY calories LIMIT 3

Answer 11

I just tried this but got an error
SELECT * FROM cakes
ORDER BY calories ASC LIMIT 3

Answer 12

SELECT *
FROM cakes
ORDER BY calories ASC LIMIT 3;

Tried and works, remember with SQL don't think too hard about your answers.

Answer 13

SELECT* FROM Cakes
ORDER BY Calories ASC LIMIT 3;

Answer 14

I need someone who can halp me in my code

Answer 15

SELECT * FROM cakes ORDER BY calories ASC LIMIT 3

Answer 16

SELECT * FROM cakes ORDER BY calories LIMIT 3

Answer 17

Here is my answer :

SELECT * FROM cakes
ORDER BY calories ASC LIMIT 3