SQL Query Generator Prompts

Describe what data you need in plain English and get the exact SQL query with explanations, optimizations, and compatibility notes.

201 prompts
Education
Academic Research Grant Performance Analysis →
Create a complex SQL query to evaluate research grant effectiveness across multi...
research grants academic performance citation tracking
Business
Remote Work Productivity Measurement →
Create a SQL query analyzing remote work productivity across different industrie...
remote work productivity workforce analytics
Marketing
E-commerce Holiday Shopping Peak Hours →
Generate a SQL query to analyze hourly transaction volumes during the holiday se...
ecommerce sales holiday time analysis
Finance
Startup Funding Ecosystem Analysis →
Create a SQL query that maps startup funding networks, tracking investment flows...
startups venture capital investment
Education
Language Learning Platform User Progress →
Generate a SQL query tracking multilingual learners' progression, identifying le...
language learning user analytics education
Science
Personal Carbon Footprint Tracking →
Design a SQL query that calculates individual carbon footprints by integrating l...
sustainability carbon tracking lifestyle
Technology
Virtual Reality Training Effectiveness Analysis →
Design a SQL query to track VR training performance across different industries,...
VR training performance metrics learning analytics
Business
Sustainable Fashion Supply Chain Tracking →
Generate a complex SQL query to map a sustainable fashion brand's supply chain, ...
sustainable fashion supply chain ethical production
Education
Online Learning Platform Engagement Metrics →
Create a complex SQL query to evaluate student engagement on an online learning platform.
e-learning student analytics education technology
Entertainment
E-Sports Tournament Performance Metrics →
Design a SQL query that calculates player ranking progression, win rate trends, ...
gaming statistics competitive analysis
Entertainment
Music Festival Audience Demographics Analysis →
Create a comprehensive query that analyzes music festival ticket sales, audience...
music festivals audience insights marketing
Science
Precision Agriculture Crop Management →
Design a SQL query that tracks crop health using satellite imagery, soil sensor ...
precision agriculture crop management data analysis
Business
Professional Networking Skills Gap Analysis →
Design a query that identifies skills gaps in professional networks, tracking in...
professional development skills analysis networking
Technology
Autonomous Vehicle Performance Tracking →
Design a SQL query that monitors autonomous vehicle performance, including safet...
autonomous vehicles performance tracking technology
Health
Hospital Resource Utilization Tracking →
Generate a SQL query that tracks medical equipment usage across different hospital departments.
medical-management resource-optimization healthcare-analytics
Technology
Telecommunication Network Performance Optimization →
Design a SQL query that analyzes cellular network performance metrics, tracking ...
network-performance telecom-analytics infrastructure-optimization
Health
Pharmaceutical Drug Interaction Research →
Design a complex SQL query that maps potential drug interactions, side effect pr...
medical-research drug-interactions pharmaceutical-analytics
Health
Mental Health App User Journey Mapping →
Design a SQL query analyzing user interactions in a mental health tracking app, ...
mental health app analytics user engagement
Science
Urban Vertical Farming Ecosystem →
Develop a SQL query tracking urban vertical farming performance, analyzing crop ...
vertical farming urban agriculture sustainability
Education
Interactive Museum Visitor Engagement Analysis →
Generate a SQL query to track visitor interactions in an interactive museum, mea...
museum analytics visitor tracking interactive learning
Education
Interactive Museum Experience Design →
Develop a SQL query that optimizes museum exhibit interactions by tracking visit...
museums visitor experience technology
Marketing
E-commerce Product Performance Across Seasons →
Design a query that tracks seasonal product performance, comparing sales volume,...
ecommerce seasonal trends sales analysis
Health
Hospital Resource Allocation During Pandemic →
Create a SQL query that analyzes hospital bed occupancy, staff scheduling, and p...
healthcare pandemic response resource management
Entertainment
Esports Tournament Player Performance Metrics →
Generate a query that tracks individual player performance across multiple espor...
esports player analytics tournament data
Business
Urban Real Estate Investment Trends →
Develop a SQL query that analyzes property values, neighborhood development, ren...
urban development real estate investment
Health
Telemedicine Patient Engagement Analysis →
Design a SQL query that tracks patient engagement in telemedicine, analyzing con...
telemedicine patient analytics healthcare
Finance
Cryptocurrency Trading Pattern Analysis →
Design a query that tracks cryptocurrency trading volumes, price volatility, mar...
cryptocurrency trading market analysis
Science
Space Mission Resource Allocation →
Develop a SQL query that tracks space mission resource utilization, equipment pe...
space exploration mission analytics research
Technology
Smart City IoT Infrastructure Performance →
Create a comprehensive query that monitors urban IoT device performance, energy ...
smart city IoT infrastructure analytics
Technology
Emerging Technology Patent Landscape →
Develop a SQL query that analyzes global patent trends, tracking emerging techno...
patent analysis technology trends innovation
Business
E-commerce Customer Lifetime Value Analysis →
Create a complex SQL query that calculates customer lifetime value by segmenting...
ecommerce analytics customer-value
Technology
Urban Traffic Pattern Temporal Analysis →
Design a SQL query that analyzes traffic sensor data to identify peak congestion...
urban-planning traffic-analysis data-science
Technology
Renewable Energy Grid Performance Dashboard →
Design a SQL query that aggregates solar and wind energy production data, tracki...
renewable-energy sustainability data-visualization
Entertainment
Streaming Platform Content Recommendation Engine →
Develop a complex SQL query that analyzes user viewing history, genre preference...
streaming recommendation-system user-behavior
Entertainment
Professional Esports Tournament Performance Metrics →
Create a comprehensive SQL query tracking professional gaming performance metric...
esports gaming-analytics performance-tracking
Technology
Machine Learning Model Performance Benchmarking →
Design a SQL query that compares machine learning model performance across diffe...
machine-learning data-science model-evaluation
Science
Climate Change Impact on Global Agriculture →
Develop a SQL query analyzing historical crop yield data, temperature variations...
climate-change agricultural-sustainability environmental-modeling
Marketing
Digital Marketing Campaign Multivariate Analysis →
Create a complex SQL query that performs multivariate analysis on digital market...
digital-marketing campaign-analysis customer-insights
Finance
Global Financial Market Sentiment Analysis →
Create a SQL query that aggregates financial news sentiment, social media discus...
financial-analysis market-sentiment investment-research
Technology
Smart City Infrastructure Planning →
Develop a SQL query that integrates urban infrastructure data, including public ...
smart-city urban-technology infrastructure-analysis
Education
Global Language Learning Trends →
Design a SQL query that analyzes language learning platform data, tracking user ...
language-learning global-education user-behavior
Business
Global E-commerce Consumer Behavior Analysis →
Design a SQL query that analyzes cross-border e-commerce trends, tracking intern...
e-commerce global-markets consumer-behavior
Business
E-commerce Product Performance Analysis →
Create a SQL query to identify top-selling products with profit margins above 30...
sales analytics performance e-commerce
Science
Sustainable Agriculture Crop Yield Prediction →
Design a SQL query to cross-reference weather data, soil conditions, and histori...
farming data analysis sustainability crop yield
Entertainment
Music Streaming Platform Genre Evolution →
Create a SQL query to track the emergence and decline of music genres over the p...
music trends streaming data analysis
Finance
Cryptocurrency Trading Pattern Insights →
Generate a SQL query to analyze cryptocurrency trading volumes, price volatility...
cryptocurrency trading market analysis blockchain
Business
Remote Work Productivity Assessment →
Create a SQL query to analyze employee productivity metrics across different rem...
remote work productivity workforce analysis HR
Science
Renewable Energy Grid Performance →
Design a SQL query to evaluate renewable energy grid performance, comparing sola...
renewable energy grid performance sustainability data analysis
Science
Global Climate Change Impact Study →
Create a SQL query to correlate temperature changes, sea level rise, and biodive...
climate change environmental research data analysis sustainability
Education
Educational Technology Learning Outcomes →
Develop a SQL query to analyze online learning platform data, tracking student e...
edtech learning analytics student performance online education
Health
Personalized Fitness Recommendation Engine →
Generate a SQL query to create a recommendation system for fitness programs, ana...
fitness personalization health tracking recommendation system
Business
Urban Real Estate Investment Analysis →
Create a SQL query to evaluate real estate investment potential by combining pro...
real estate investment data analysis urban development
Marketing
Social Media Influencer Impact Measurement →
Design a SQL query to quantify social media influencer effectiveness by analyzin...
social media influencer marketing data analysis engagement
Technology
Personalized Content Recommendation System →
Develop a SQL query to create a sophisticated content recommendation algorithm t...
recommendation system content personalization user engagement machine learning
Science
Precision Agriculture Crop Management →
Generate a SQL query to integrate satellite imagery, soil sensor data, weather f...
precision agriculture farming data integration crop management
Health
Mental Health Digital Intervention Analysis →
Create a SQL query to evaluate the effectiveness of digital mental health interv...
mental health digital health intervention analysis well-being
Technology
Predictive Maintenance for Industrial Equipment →
Generate a SQL query to develop a predictive maintenance model for industrial ma...
predictive maintenance industrial equipment data analysis IoT
Marketing
Cross-Cultural Consumer Behavior Study →
Create a SQL query to analyze consumer behavior across different cultural contex...
consumer behavior cultural analysis marketing research global trends
Science
Disaster Response Resource Allocation →
Create a SQL query to optimize disaster response resource allocation by analyzin...
disaster response resource allocation emergency management data analysis
Finance
Eco-Friendly Restaurant Supply Chain Tracking →
Generate a complex SQL query that tracks carbon footprint across restaurant ingr...
sustainability supply chain environmental tracking