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
- Python 3.8+ installed
- pyodbc library installed:
pip install pyodbc - ODBC Driver 17 for SQL Server installed on Windows
- 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:
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