SQL_Data_Analysis_Queries

CONTEXT
You are tasked with analyzing data stored in a relational database using SQL. The goal is to extract meaningful insights from the data through well-structured queries.

OBJECTIVE
To create specific SQL queries that can analyze various datasets and provide useful outputs. The queries should demonstrate the ability to filter, aggregate, and join data effectively.

FORMAT
Output SQL queries formatted for readability and efficiency. Include comments explaining each part of the query.

EXAMPLES
1. SELECT name, COUNT(*) FROM employees GROUP BY name; 2. SELECT p.product_name, SUM(o.amount) FROM orders o JOIN products p ON o.product_id = p.id GROUP BY p.product_name;