repeating-sql/select-from-invoice-7.8.sql at main · Bujhm/repeating-sql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
/*
Created by: Ihor Semeniuk
Create Date: 09/12/2023
Decscription: Nesting functions
*/
SELECT
	ROUND(SUM(Total), 2) AS [Total sales],
    ROUND(AVG(Total), 2) AS [Average sale],
    MAX(Total) AS [MAximum sale],
    MIN(Total) AS [Minimum sale],
    COUNT(*) AS [Number of sales]
FROM
	Invoice