FAQ: Aggregate Functions - Sum

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 “Sum” 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 Sum

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 it isn’t SELECT SUM(‘downloads’) with the ’ ’ in this case?

3

In this exercise, downloads is a column name. Column names are like variables in JavaScript. We do not need to enclose them with quotation marks (i.e. ' ').

We use quotation marks for string values as data entries or for renaming columns and tables with AS (see this lesson).

2 Likes
4

What happens when SUM is used with text?
Thanks!

1 Like