Data Analysis with SQL

Given a table named “Sales” with columns “product_id,” “date,” and “revenue,” how can you retrieve the total revenue for each product for the year 2022?

How can you retrieve the distinct values of the “category” column from the “Products” table?

How can you calculate the average salary of employees in the “Employees” table?

Given a table named “Orders” with columns “order_id,” “order_date,” and “total_amount,” how can you retrieve the orders placed in August 2023

 If you want to list the top 5 highest-paid employees from the “Employees” table, how can you achieve this?

 How can you retrieve the number of orders placed by each customer from the “Orders” table?

If you have a table named “Students” with columns “student_id” and “score,” how can you find the average score?

How can you find the maximum and minimum salary in the “Employees” table?

How can you retrieve the names of employees who have a salary greater than $50,000?

If you want to retrieve all customers who have placed at least three orders, how can you achieve this?