DISTINCT vs GROUP BY

Learn the difference between DISTINCT and GROUP BY.

DISTINCT with aggregates

DISTINCT can be used inside aggregates like SUM(DISTINCT column) and AVG(DISTINCT column).

SELECT AVG(DISTINCT price) AS ort FROM products;

This query averages the non-duplicate prices.

AVG(DISTINCT price) AS ort is selected from products.

AVG(DISTINCT) counts duplicates once. SUM(DISTINCT) adds duplicates once. It is rarely used but you should know it.

Compute the average of unique prices aliased as ort from products.

Show example solution

SELECT AVG(DISTINCT price) AS ort
FROM products

Distinct average

SELECT AVG(____ price) FROM products;

Show answer

SELECT AVG(DISTINCT price) FROM products;