Course/Module 4/Topic 3 of 3Intermediate

Aggregate Functions & Grouping - Practice

Put your aggregate functions & grouping skills to the test with practical exercises and challenges.

50 min•By Priygop Team•Last updated: Feb 2026

Hands-On Practice

Practice makes perfect! In this section, you'll work through practical exercises that reinforce the concepts covered in this module.

Exercises

Exercise 1: Apply basic aggregate functions & grouping concepts
Exercise 2: Solve intermediate-level challenges
Exercise 3: Build a mini-project using aggregate functions & grouping
Exercise 4: Debug and fix common issues

Practice: Aggregate Functions & Grouping

Practice: Aggregate Functions & GroupingJavaScript⚠ 1 error

⚠ Syntax Issues (1)

Line 1: JS Error: Unexpected identifier 'aggregate'

💡 Check syntax near the highlighted line.

JavaScript Editor

✕ 1 errorTab = 2 spaces

-- Try aggregate queries!
SELECT 
  category,
  COUNT(*) AS product_count,
  ROUND(AVG(price), 2) AS avg_price,
  MAX(price) AS most_expensive
FROM products
GROUP BY category
HAVING AVG(price) > 25
ORDER BY avg_price DESC;

Result

Click ▶ Run to see the result

Edit the code on the left, then click Run

JavaScript|10 lines|222 chars|1 error, 0 warnings

UTF-8

Review Quiz

Next Module →

Chat on WhatsAppPriygop - Leading Professional Development Platform | Expert Courses & Interview Prep