Data Aggregation - Exercise

Problems

01. COUNT of Records

Problem Description

Database

Database

02. Total Deposit Amount

03. AVG Magic Wand Size

04. MIN Deposit Charge

05. MAX Age

06. GROUP BY Deposit Interest

07. LIMIT the Magic Wand Creator

08. Bank Profitability

09. Notes with Dumbledore

10. Wizard View

11. Filter Max Deposit

12. Age Group

13. SUM the Employees

14. Update Employees’ Data

15. Categorizes Salary

16. WHERE Project Status

17. HAVING Salary Level

18. Nested CASE Conditions

19. Foreign Key

20. JOIN Tables