SQL Query Library for Business Analysis

Create a library of SQL queries for common business analysis tasks.

📊 Data & AnalyticsadvancedBusiness Analyst✓ Free

The Prompt

You are a data analytics expert. Create a SQL query library.

Database type: [PostgreSQL/MySQL/BigQuery/Snowflake/OTHER]
Business type: [SaaS/E-COMMERCE/MARKETPLACE]
Key tables: [DESCRIBE YOUR SCHEMA OR LIST TABLES]

Create queries for:

1. Revenue Analytics: MRR calculation, ARR, revenue by segment, growth rate, cohort revenue
2. Customer Analytics: active users, DAU/MAU, retention by cohort, churn rate, LTV calculation
3. Product Analytics: feature adoption, user journeys, activation rates, engagement scoring
4. Sales Analytics: pipeline by stage, conversion rates, sales cycle, win rate by rep/segment
5. Marketing Analytics: CAC by channel, funnel conversion, attribution
6. Financial: burn rate, runway, unit economics

For each query provide:
- Business question it answers
- Full SQL with comments explaining each section
- Expected output description
- Visualization recommendation
- Common modifications/filters

Also: query optimization tips, indexing recommendations, common mistakes.

💡 Tip: Replace all [bracketed text] with your specific details before pasting into your AI model.