Any assistance please?

Question

Please guys kindly help me with all the codings for the 3 projects whilst learning the sql . I'm only left with 3 projects for my certificate. Please I need your support.

Answer 1

In order for us to help you we need the task description, we need to see your code attempt and we need to see what you've searched for to resolve your problem.
Can you help us out?

https://code.sololearn.com/Wek0V1MyIR2r/?ref=app
https://code.sololearn.com/W0uW3Wks8UBk/?ref=app
https://code.sololearn.com/W3uiji9X28C1/?ref=app

Answer 2

Prince Adjei ,

there are 2 issues in the code:

> the statement only selects the field *calories*, but should select *name, calories*

> the 3rd line ends with a semicolon *;*. this should only be used in the last line.

Answer 3

You are close to get the correct query and answer.

Your output is different because, there is error on line 3 near *ORDER BY* keyword.

Check what the task is asking you to do. As above you stated, ```
Write a query to {sort the cakes by calorie count} and select the first 3 cakes from the list to offer the customer.```

-> means rather it should be calories and not cakes.

Answer 4

What is the code meant to do?
Review the lesson, and see what might go under the "//your code goes here"

Answer 5

Prince Adjei, it might be good to review the lessons and maybe do some further research. It's no good if you aren't able to solve them mostly by yourself, otherwise you will be dependent on others for a long time.

If you're still having trouble with any other task, please copy the task description and attach your code attempt.

Answer 6

Great news that you finished the course!

I think your code is fine. The issue is that the task doesn't ask for you to write "Enter the difficulty...."

Answer 7

We need to see your code too.
It looks like it should include an if/else section based on the contains method.

Answer 8

"""SELECT name,calories
FROM cakes
ORDER BY calories
LIMIT 3;"""

This one worked for me

Answer 9

You just need to think about the need behind what you're doing. Read carefully what you're asked to do and organize the ideas so that you get the correct query.

Answer 10

Thanks for your responses y'all. Cert obtained successfully

Answer 11

SELECT calories
FROM cakes
ORDER BY calories;
LIMIT 3;

Answer 12

A local bakery creates unique cake sets. Each cake set contains three different cakes.
Here is the cakes table:

Answer 13

Т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.

Answer 14

Try to combine ORDER BY and LIMIT

Answer 15

SELECT name,calories
FROM cakes
ORDER BY cakes
LIMIT 3;

The output is not working please

Answer 16

My output is different from the real answer

Answer 17

I think you misunderstood what you're supposed to order with your query. What's the customer need for the cake ?

Answer 18

It hurts me dat I can't post a screenshot of all that I mean

Answer 19

"sort the cakes by calorie count"

According to you, what is your current query doing ?

Your customer doesn't want to know what the sets are, they want to know which cake sets have the less calories (more precisely the three ones that have the less calories).

How would you translate that in SQL ? Which combination of keywords will give exactly what the customer wants ?

Answer 20

Also, remember that ORDER BY takes an attribute name as argument not a table name, so you can't do "ORDER BY cakes".