Demonstration Environment
This project contains fictional companies, employees, customers, financial records, and business data created solely for software demonstration purposes. Any resemblance to real businesses or individuals is purely coincidental.
SQL Explorer
Query the data. Find the answer.
Database Query Audit #004
Business Teams Need Faster Access to Customer and Sales Data
ForgePoint Manufacturing stores customer, order, and revenue information across related data tables. Non-technical teams frequently request reports, but each question requires someone to manually locate, filter, and combine records.
Objective: Demonstrate how SQL queries can retrieve meaningful business information from relational data using filtering, grouping, sorting, and joins.
Top Customers by Revenue
SELECT
customers.customer_name,
customers.region,
COUNT(orders.order_id) AS total_orders,
SUM(orders.revenue) AS total_revenue
FROM customers
JOIN orders
ON customers.customer_id = orders.customer_id
WHERE orders.order_date BETWEEN '2026-04-01' AND '2026-06-30'
GROUP BY
customers.customer_name,
customers.region
ORDER BY total_revenue DESC
LIMIT 5;Identifies the highest-value customers during Q2.
This query joins customer records with order history, filters the data to Q2, groups revenue by customer, and returns the top accounts by total revenue.
Returned Records
| Customer | Region | Total Orders | Total Revenue |
|---|---|---|---|
| ForgePoint Manufacturing | East | 184 | $487,240 |
| Summit Industrial Group | North | 143 | $392,880 |
| Blue Ridge Components | South | 128 | $341,610 |
| Iron Valley Supply | West | 112 | $286,430 |
| Cumberland Equipment Co. | East | 97 | $244,900 |
How the SQL Query Works
Chooses which columns appear in the final report.
Connects customers to their related orders.
Filters the records to only show Q2 sales activity.
Combines orders by customer and region.
Sorts customers from highest revenue to lowest.
Returns only the top five results.