0

Can you help me please with 8 coding project, pies.

Read the problem again there is not city. You want to get the list of 3 cakes which has minimum calories so you can use here ORDER BY and LIMIT. 8 coding project, pies

1st May 2021, 2:42 PM
Шестаков Алексей Александрович
4 odpowiedzi
+ 6
Шестаков Алексей Александрович Pls post your attempt if you want help in Q&A. If you want codes to refer you can find it in the Code section .Also,Kindly use the search bar before posting Questions .
1st May 2021, 2:43 PM
Kǟrɨsɦmǟ ❥
Kǟrɨsɦmǟ ❥ - avatar
+ 1
SELECT * FROM cakes ORDER BY calories LIMIT 3
6th Dec 2021, 5:21 PM
SecDet
SecDet - avatar
0
It is not possible for us to give you an answer as you have not provided the SQL database field titles. However I can direct you to the lesson about LIMIT and ORDER BY LIMIT https://www.sololearn.com/learn/SQL/1853/ ORDER BY https://www.sololearn.com/learn/SQL/1854/
1st May 2021, 2:59 PM
Gordon
Gordon - avatar
0
I just can't solve this task. I wrote a query: SELECT * FROM cakes ORDER BY calories LIMIT 3. And it looks right, but the system does not protect it, because the name of cakes is displayed with a small letter, but it should be with a large one
1st May 2021, 3:38 PM
Шестаков Алексей Александрович