FAQ: Aggregate Functions - Round


#1

This community-built FAQ covers the “Round” exercise from the lesson “Aggregate Functions”.

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

Web Development
Data Science

Learn SQL

FAQs on the exercise Round

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

I still don’t understand why the numeral (2) is used to round to an average of two decimal places.


#3
SELECT ROUND(price, 0)
FROM fake_apps;

The above example rounds to the nearest integer.

SELECT ROUND(price, 2)
FROM fake_apps;

The above example rounds to the nearest second decimal place.

ROUND(123.456, 2)    //  123.46

#4

Question:

If the function takes in a column name, how does avg(prices) qualify as one? I thought avg(prices) returns a single value?

Can someone elaborate. Thanks