Prompt Details

ModelChat GTP 4Example input

[Data__Request]: Calculate the monthly revenue growth rate for the 'orders' table for the year 2023.

Example output

-- Calculate Monthly Revenue and Growth Rate
WITH MonthlyRevenue AS (
    SELECT 
        DATE_FORMAT(order_date, '%Y-%m') AS month,
        SUM(total_amount) AS revenue
    FROM orders
    WHERE YEAR(order_date) = 2023
    GROUP BY 1
)
SELECT 
    month,
    revenue,
    LAG(revenue) OVER (ORDER BY month) AS previous_month_revenue,
    (revenue - LAG(revenue) OVER (ORDER BY month)) / LAG(revenue) OVER (ORDER BY month) * 100 AS growth_rate_percent
FROM MonthlyRevenue;

Preview Output Generated by This Prompt

Category:

Business

Management

Tags:

Business development

Data

SQL Query Builder & Optimizer Pro | GPT Prompt

Name: SQL Query Builder & Optimizer Pro
Brand: LaPrompt
SKU: DaEziFDu
Price: 3.99 USD
Availability: InStock
Author: user_7193111c388447ec