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
4 Antworten
+ 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 .
+ 1
SELECT * FROM cakes ORDER BY calories LIMIT 3
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/
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