Icon New game New game

Mastering SQL Aggregation Problems

Fill in the Blanks

Drills to master SQL aggregation problems

Download the paper version to play

0 times made

Created by

United States

Top 10 results

There are still no results for this game. Be the first to stay in the ranking! to identify yourself.
Make your own free game from our game creator
Compete against your friends to see who gets the best score in this game

Top Games

  1. time
    score
  1. time
    score
time
score
time
score
 
game-icon

Fill in the Blanks

Mastering SQL Aggregation ProblemsOnline version

Drills to master SQL aggregation problems

by Good Sam
1

AS amount sales total_sales SUM SELECT FROM

Problem 1 : Total Sales
Question : You have a table sales ( order_id INT , amount DECIMAL ) . Write a SQL query to calculate the total sales amount .

Solution :

( )
;





SELECT SUM ( amount ) AS total_sales
FROM sales ;

Explanation : The SUM ( ) function aggregates the total sales by summing up all the amount values in the sales table .

2

average_sale_amount AVG sales amount AS FROM SELECT

Problem 2 : Average Sales per Order
Question : Calculate the average sales amount per order from the sales table .

Solution :

( )
;





SELECT AVG ( amount ) AS average_sale_amount
FROM sales ;

Explanation : The AVG ( ) function calculates the average amount of sales by dividing the total sum of the amount column by the count of rows ( i . e . , number of orders ) .

3

SELECT AS DISTINCT distinct_products FROM COUNT order_details product_id

Problem 3 : Count of Distinct Products Sold
Question : Given a table order_details ( order_id INT , product_id INT ) , find the number of distinct products sold .

Solution :

( )
;






SELECT COUNT ( DISTINCT product_id ) AS distinct_products
FROM order_details ;

Explanation : COUNT ( DISTINCT product_id ) counts the unique product IDs in the order_details table , ignoring duplicates .

4

SELECT FROM amount MAX amount AS AS MIN max_sale min_sale sales

Problem 4 : Maximum and Minimum Sale
Question : Find both the largest and smallest sale amounts from the sales table .

Solution :

( ) , ( )
;






SELECT MAX ( amount ) AS max_sale , MIN ( amount ) AS min_sale
FROM sales ;

Explanation : The MAX ( ) and MIN ( ) functions are used to find the highest and lowest values in the amount column of the sales table .

5

FROM sales MONTH ORDER sale_date BY AS sale_date sale_month YEAR sale_date FROM AS sale_month FROM total_sales sale_year EXTRACT YEAR EXTRACT SUM SELECT FROM sale_year amount GROUP EXTRACT AS sale_date BY EXTRACT MONTH FROM

Problem 5 : Grouped Sales by Month
Question : Assuming a table sales ( order_id INT , amount DECIMAL , sale_date DATE ) , calculate total sales for each month .

Solution :

( ) ,
( ) ,
( )

( ) , ( )
, ;











SELECT EXTRACT ( YEAR FROM sale_date ) AS sale_year ,
EXTRACT ( MONTH FROM sale_date ) AS sale_month ,
SUM ( amount ) AS total_sales
FROM sales
GROUP BY EXTRACT ( YEAR FROM sale_date ) , EXTRACT ( MONTH FROM sale_date )
ORDER BY sale_year , sale_month ;

Explanation : The SUM ( ) function is used to aggregate sales per month , grouped by year and month extracted from sale_date . The GROUP BY clause groups the data into sets that share the same year and month so that SUM ( ) can compute totals for each group .

educaplay suscripción