SQL Reports#

Query Delivery Orders from SQL Server and generate delivery reports for business analysis.

Overview#

This skill connects to a SQL Server database to extract and analyze delivery order data. It's designed for warehouse managers and logistics teams who need quick access to delivery statistics without writing SQL queries manually.

Database Connection#

• Server: LTEDP056\SQLEXPRESS
• Port: 1433
• Database: DeliveryDB
• Driver: ODBC Driver 17 for SQL Server

Prerequisites#

1. Python 3.8+ installed
2. pyodbc library installed: pip install pyodbc
3. ODBC Driver 17 for SQL Server installed on Windows
4. Network access to LTEDP056 server on port 1433

Available Queries#

1. summary_by_month#

Returns monthly delivery summary with total orders, revenue, and delivery status breakdown.

Output: Table with Month, TotalOrders, TotalRevenue, Delivered, Pending, Cancelled columns

2. monthly_comparison#

Compare delivery performance between two months.

Input: Month1 (YYYY-MM), Month2 (YYYY-MM) Output: Side-by-side comparison table

3. quarterly_report#

Generate comprehensive quarterly delivery report with trends.

Input: Year (YYYY), Quarter (1-4) Output: Detailed report with weekly breakdown

4. summary_by_year#

Annual delivery summary with year-over-year growth metrics.

Input: Year (YYYY) Output: Annual statistics and growth indicators

Usage#

Run from command line:

bash

python query.py summary_by_month
python query.py monthly_comparison 2025-01 2025-02
python query.py quarterly_report 2025 1
python query.py summary_by_year 2025