# Advanced Querying - Aggregate Functions
# Practice Questions
Use the magic store database for the following queries.
- Write a query to find the total number of orders placed in 2021.
Expected result:
- Write a query to calculate the minimum, average and maximum price of all products supplied by “Elixir Essentials”.
Expected result:
# Lessons
- SQL - W10 Advanced Querying - Introduction
- SQL - W10 Advanced Querying - Aggregate Functions
- Next: SQL - W10 Advanced Querying - Column Aliasing
- SQL - W10 Advanced Querying - Calculating Values
- SQL - W10 Advanced Querying - Northwind Database
- SQL - W10 Advanced Querying - GROUP BY
- SQL - W10 Advanced Querying - Data Analytics with GROUP BY
- SQL - W10 Advanced Querying and Data Analytics Assignment