Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
- Counting Results 4:41
- Counting Results 2 objectives
- Counting Groups of Rows 2:21
- Counting Groups 2 objectives
- Getting the Grand Total 5:31
- Summing Values 1 objective
- Calculating Averages 2:01
- Averaging Values 1 objective
- Getting Minimum and Maximum Values 2:08
- Calculating the Minimum and Maximum Values 1 objective
- Performing Math on Numeric Types 4:35
- Performing Math 1 objective
- Practice Session 2:31
- Review: Aggregate and Numeric Functions 5 questions
Start a free Courses trial
to watch this video
![](https://videos.teamtreehouse.com/stills/TH-ReportingWithSQL-Stage3-Video7-stills-8.jpg?token=6991e1dc_39a77f6b7d1e2499eaa15a4112703f958aac11f7)
- 2x 2x
- 1.75x 1.75x
- 1.5x 1.5x
- 1.25x 1.25x
- 1.1x 1.1x
- 1x 1x
- 0.75x 0.75x
- 0.5x 0.5x
Let's practice the new keywords, operators and functions you've learned in this section.
Cheat Sheets
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up-
Aquoinette Blair
3,539 Points2 Answers
-
Freddie Kuhle
8,037 PointsSQL - How can I add a column from one table to my results from another table?
Posted by Freddie KuhleFreddie Kuhle
8,037 Points1 Answer
-
Sean Flanagan
33,236 Points2 Answers
-
Krishna Diamesso
33,880 Points3 Answers
-
Jonatan Spahn
6,362 PointsUser Average Rating, a little more advanced using subqueries
Posted by Jonatan SpahnJonatan Spahn
6,362 Points1 Answer
-
Jonatan Spahn
6,362 Points3 Answers
-
Jan Lundeen
5,887 PointsOn SQL Playground, Stage 3, Practice, how do I calculate the average movie rating and round it to 1 decimal place?
Posted by Jan LundeenJan Lundeen
5,887 Points3 Answers
View all discussions for this video
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up