+ 4

Help I'm stuck

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;

15th Feb 2021, 7:11 AM
merve esen
merve esen - avatar
17 Answers
0
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!
15th Feb 2021, 7:38 AM
ChaoticDawg
ChaoticDawg - avatar
+ 4
Best solution of this code SELECT * FROM Cakes ORDER BY Calories LIMIT 3;
1st Dec 2021, 10:50 AM
Nichervan Essa Mahammad
Nichervan Essa Mahammad - avatar
+ 1
Same issue here it always shows error please help me My code SELECT * FROM cakes ORDER BY calories Limit 3;
1st May 2021, 8:06 AM
faizal shaikh
faizal shaikh - avatar
+ 1
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).
25th Oct 2022, 4:09 PM
Uddesh Patil
Uddesh Patil - avatar
0
SELECT * FROM cakes ORDER BY Calories limit 3;
18th May 2021, 3:19 PM
SHILPA
SHILPA - avatar
0
SELECT name FROM cakes ORDER BY Calories LlMIT 3;
18th May 2021, 3:21 PM
faizal shaikh
faizal shaikh - avatar
0
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(
5th Jun 2021, 11:57 AM
Viacheslav Nechyporenko
Viacheslav Nechyporenko - avatar
0
3rd Jul 2021, 11:24 AM
Prathamesh Shirke
0
SELECT * FROM cakes ORDER BY calories ASC LIMIT 3 working! ASC - sort result in ascending order.
16th Aug 2021, 5:23 AM
Maryna Leshchenko
Maryna Leshchenko - avatar
0
SELECT name,min(calories) FROM cakes GROUP BY calories LIMIT 3. ***But still not output.
7th Nov 2021, 11:59 PM
Moon14
Moon14 - avatar
0
SELECT * FROM cakes ORDER BY calories LIMIT 3
24th Dec 2021, 9:43 AM
Addisu Amsalu
Addisu Amsalu - avatar
0
I just tried this but got an error SELECT * FROM cakes ORDER BY calories ASC LIMIT 3
5th Feb 2022, 4:18 PM
Ifeoma Njogwuani
0
SELECT * FROM cakes ORDER BY calories ASC LIMIT 3; Tried and works, remember with SQL don't think too hard about your answers.
13th Jun 2022, 1:07 AM
Jessica Cazacopol
0
SELECT* FROM Cakes ORDER BY Calories ASC LIMIT 3;
8th Aug 2022, 8:15 PM
Goel Aman Lal
Goel Aman Lal - avatar
1
SELECT * FROM cakes ORDER BY calories ASC LIMIT 3
3rd Jul 2021, 11:24 AM
Prathamesh Shirke
2
SELECT * FROM cakes ORDER BY calories LIMIT 3
6th Apr 2021, 5:35 AM
Yuliya Huts
Yuliya Huts - avatar
6
Here is my answer : SELECT * FROM cakes ORDER BY calories ASC LIMIT 3
5th Apr 2021, 9:05 AM
Gaël-Freddy GAGOUDE
Gaël-Freddy GAGOUDE - avatar