Average Salaries Per Department

# Introduction

In this project, you will learn how to calculate the average salary for each department in a database and display the results in descending order using SQL queries.

## 👀 Preview

MariaDB [edusys]> SOURCE ~/project/singleTableQuery.sql
+------------+--------------+
| dept_name  | avg_salary   |
+------------+--------------+
| Physics    | 91000.000000 |
| Finance    | 85000.000000 |
| Elec. Eng. | 80000.000000 |
| Comp. Sci. | 77333.333333 |
| Biology    | 72000.000000 |
| History    | 61000.000000 |
| Music      | 40000.000000 |
+------------+--------------+
7 rows in set (0.001 sec)

## 🎯 Tasks

In this project, you will learn:

- How to start the MySQL server and import a database
- How to write an SQL query to group data by department and calculate the average salary
- How to order the results in descending order based on the average salary

## 🏆 Achievements

After completing this project, you will be able to:

- Understand how to use SQL's `SELECT`, `FROM`, `WHERE`, `GROUP BY`, and `ORDER BY` clauses to perform data analysis
- Implement a SQL query to calculate and display the average salaries per department in descending order
- Apply your SQL knowledge to solve real-world data analysis problems