coding

SQL Query for Monthly Sales Report

Write an SQL query to generate monthly sales data

The Prompt

Create an SQL query that calculates monthly sales totals from a [TABLE_NAME] table. Group by month and year, and include columns for total revenue, number of transactions, and average order value. Replace [TABLE_NAME] with your actual table name.

When to use this

For generating business intelligence reports from relational databases.

Pro tips

→Include filters for specific regions or product categories.
→Add a WHERE clause for date ranges.

⚡ Level up — premium tools for this

PostgreSQL Natural Language MCP

$44

Stripe Revenue MCP

$39

More coding prompts

📋

Python Function for Data Cleaning

Generate a Python function to clean and preprocess datasets

📋

React Component for Dashboard

Create a reusable React component for a dashboard

📋

GitHub Actions Workflow for CI/CD

Set up a GitHub Actions workflow for continuous integration

📋

Bash Script for Log Rotation

Create a Bash script to automate log file rotation

📋

JavaScript Utility for Form Validation

Generate a reusable JavaScript utility for form validation

📋

Dockerfile for Node.js Application

Create a Dockerfile for a Node.js application

View all coding prompts →