Please someone should solve cakes in SQL. I'm desperate | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Please someone should solve cakes in SQL. I'm desperate

SQL

18th Jan 2021, 1:00 PM
Charles Ugwu
Charles Ugwu - avatar
6 Answers
+ 3
I did this:- SELECT * FROM cakes ORDER BY calories LIMIT 3; I selected each set using the *(wild card) from the table cakes. You should order them by their calories(smallest to largest) using ORDER BY keyword but you need to show the first three sets using the LIMIT keyword.
18th Jan 2021, 1:13 PM
Kanji-50
Kanji-50 - avatar
+ 1
Charles Ugwu Show your attempt and I will help you.
18th Jan 2021, 1:03 PM
Kanji-50
Kanji-50 - avatar
+ 1
Thanks man
18th Jan 2021, 1:14 PM
Charles Ugwu
Charles Ugwu - avatar
0
SELECT name, calories FROM customers ORDER BY name, calories FROM customers LIMIT 3
18th Jan 2021, 1:06 PM
Charles Ugwu
Charles Ugwu - avatar
0
Charles Ugwu Your welcome.
18th Jan 2021, 1:15 PM
Kanji-50
Kanji-50 - avatar
0
SELECT name, calories FROM cakes ORDER BY calories LIMIT 3;
5th Oct 2021, 12:54 PM
Fatemeh Afsahhosseini
Fatemeh Afsahhosseini - avatar