question

mbwe avatar image
mbwe asked

,Please help with an sql statement for the problem below

![alt text][1] [1]: /storage/temp/1636-count%20problem.jpg
sqlhomeworkcount
count%20problem.jpg (90.2 KiB)
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What have you tried so far? Can you describe what you are trying to do using words in addition to the picture? The SQL statement often looks remarkably similar to the english problem description. If this is homework, you should have a similar example from lecture or bookwork that can be easily adapted to this problem.
1 Like 1 ·

1 Answer

· Write an Answer
Wilfred van Dijk avatar image
Wilfred van Dijk answered
I'll give you a hint: your query has a GROUP BY statement. If you take a look at the picture, you'll see the grouping field
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.