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:

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