FAQ: Code Challenge: Aggregate Functions - Code Challenge 6

Frequently Asked Questions SQL FAQ
1

Community%20FAQs%20on%20Codecademy%20Exercises
Community%20FAQs%20on%20Codecademy%20Exercises1000×208 141 KB

This community-built FAQ covers the “Code Challenge 6” exercise from the lesson “Code Challenge: Aggregate Functions”.

Paths and Courses
This exercise can be found in the following Codecademy content:

Web Development
Data Science

FAQs on the exercise Code Challenge 6

Join the Discussion. Help a fellow learner on their journey.

Ask or answer a question about this exercise by clicking reply (reply) below!

Agree with a comment or answer? Like (like) to up-vote the contribution!

Need broader help or resources? Head here.

Looking for motivation to keep learning? Join our wider discussions.

Learn more about how to use this guide.

Found a bug? Report it!

Have a question about your account or billing? Reach out to our customer support team!

None of the above? Find out where to ask other questions here!

2

Why should be ROUND(SUM()) ? Why cannot be SUM(ROUND()) ?

1 Like
3

DId you ever get an answer to this? I have the same question:
SELECT SUM(ROUND(watch_duration_in_minutes,0))

FROM watch_history

;

4

Is it important to notice the second argument 0 for rounding? I’ve just ran this without 0 and it worked