Write Complex SQL Queries

Generate optimized SQL queries for complex analysis with CTEs, JOINs, and performance tips.

📝 The Prompt

Write a SQL query for the following analysis: Database: [PostgreSQL/MySQL/SQLite] Tables: [LIST TABLES AND COLUMNS] Relationships: [HOW TABLES CONNECT] Analysis: [WHAT YOU WANT TO ANALYZE] Requirements: 1. Use CTEs for readability 2. Appropriate JOINs 3. Handle NULLs 4. Comments explaining logic 5. Optimize for performance 6. Include sample output Also: Logic explanation, assumptions, suggested indexes, alternatives.

💡 Tips for Better Results

Always specify database type — syntax differs.

🎯 Use Cases

Data analysts, backend developers, BI, reporting.

🔗 Related Prompts

📊 Data & Analytics intermediate

Python Data Analysis Script

Generate a complete Python data analysis pipeline with cleaning, visualization, and insights.

👁️ 1 📋 0
📊 Data & Analytics intermediate

Build an RFM Customer Segmentation Model for Targeted Marketing

Create a complete RFM customer segmentation model with scoring logic, code implementation, and marketing strategies.

👁️ 1 📋 5
📊 Data & Analytics advanced

Design a Robust ETL Pipeline Architecture for Your Data Platform

Design a complete ETL pipeline architecture with extraction, transformation, loading strategies, error handling, and governance.

👁️ 0 📋 0
📊 Data & Analytics intermediate

Create a Comprehensive Data Quality Checklist for Your Dataset

Generate a tailored data quality checklist with SQL validation queries, severity levels, and a scoring framework for any dataset.

👁️ 0 📋 0
📊 Data & Analytics advanced

Analyze and Interpret A/B Test Results with Statistical Rigor

Get a complete A/B test analysis with statistical significance, power analysis, validity checks, and a clear ship decision.

👁️ 0 📋 0
📊 Data & Analytics advanced

Design a Scalable ETL Pipeline Architecture for Your Data Platform

Design a production-ready ETL pipeline architecture with tool recommendations, error handling, and scalability strategies.

👁️ 0 📋 0