SQL Project Insights
A presentation of key business
queries and their value
Total Sales Revenue
• Purpose: Calculates overall revenue.
• Logic: Multiplies product price by quantity and
adjusts for discounts.
• Business Value: Helps evaluate total income
from sales.
Top 5 Selling Products
• Purpose: Identifies best-selling products.
• Logic: Sums quantity sold per product.
• Business Value: Useful for inventory planning
and promotion.
Monthly Sales Trend
• Purpose: Shows how revenue varies month by
month.
• Logic: Groups order dates by month and sums
revenues.
• Business Value: Reveals seasonal trends and
business cycles.
Customer with Highest Spend
• Purpose: Finds the top customer by total
purchases.
• Logic: Aggregates total amount spent per
customer.
• Business Value: Important for customer
relationship management.
Best Performing Store
• Purpose: Shows which store generates the
most sales.
• Logic: Aggregates revenue by store.
• Business Value: Aids in performance
comparisons and strategic planning.
Average Discount Offered
• Purpose: Calculates the average discount rate.
• Logic: Uses the AVG() function on discount
field.
• Business Value: Helps monitor pricing
strategies and profitability.
Orders Without Discounts
• Purpose: Counts how many items were sold at
full price.
• Logic: Filters order items where discount = 0.
• Business Value: Assesses effectiveness of
discount policies.
Inventory Summary by Product
• Purpose: Shows current stock level per
product.
• Logic: Joins products with stocks and sums
quantities.
• Business Value: Essential for stock control and
restocking.
Low Stock Products
• Purpose: Identifies products with quantity less
than 10.
• Logic: Filters stock quantities less than 10
units.
• Business Value: Triggers replenishment and
avoids stockouts.
Category-wise Sales
• Purpose: Analyzes how different product
categories are performing.
• Logic: Sums quantity sold by category.
• Business Value: Useful for product line
planning.
Brand-wise Product Count
• Purpose: Counts how many products belong
to each brand.
• Logic: Group by brand and count rows in
products.
• Business Value: Understands brand spread in
inventory.
Total Customers per City
• Purpose: Measures geographic distribution of
customers.
• Logic: Groups customer data by city.
• Business Value: Useful for regional marketing
strategies.
Repeat Customers
• Purpose: Finds customers with more than one
order.
• Logic: Groups by customer_id and filters with
HAVING.
• Business Value: Measures customer loyalty
and retention.