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
Travel
Adventure Tourism Trend Analysis
Create a SQL query that tracks adventure tourism trends, including destination p...
adventure tourism travel trends analytics
Technology
Urban Vertical Farming Optimization
Design a SQL query to analyze vertical farming performance, tracking crop yields...
urban farming agriculture technology sustainability
Education
Rare Book Collection Provenance Tracking
Create a SQL query that maps rare book collection histories, tracking ownership ...
libraries book collection research
Business
Remote Work Productivity and Well-being
Design a SQL query to analyze remote work productivity, tracking employee engage...
remote work productivity employee analytics
Education
Academic Research Publication Network
Create a SQL query that maps interdisciplinary research collaborations, tracking...
research academia network analysis
Science
Citizen Science Environmental Monitoring
Generate a SQL query to aggregate citizen science environmental data, tracking p...
citizen science environmental monitoring community research
Technology
Renewable Energy Grid Performance Tracking
Design a SQL query that monitors renewable energy generation, grid stability, en...
renewable energy grid performance data analysis
Science
Agricultural Crop Yield Prediction Model
Create a SQL query that integrates agricultural data sources to predict crop yie...
agriculture data analysis crop management
Finance
Cryptocurrency Trading Pattern Recognition
Generate an advanced SQL query that identifies statistically significant trading...
crypto trading data analysis
Education
Language Learning Platform Performance
Create a SQL query that measures language learning effectiveness by tracking use...
language learning education technology analytics
Science
Local Food System Resilience Analysis
Generate a SQL query to map local food system resilience, tracking food producti...
local food systems agriculture community resilience
Technology
Urban Transportation Demand Prediction
Create a complex SQL query that predicts transportation demand by analyzing hist...
urban planning data analysis transportation
Design
Predictive Fashion Trend Forecasting
Create a SQL query that predicts emerging fashion trends by analyzing social med...
fashion trend analysis market research
Food
Restaurant Menu Optimization Strategy
Generate a SQL query that identifies underperforming menu items by analyzing sal...
restaurant menu profitability analytics
Science
Precision Agriculture Drone Mapping
Create a SQL query to analyze agricultural drone mapping data, tracking field co...
precision agriculture drone technology farming
Finance
Urban Real Estate Investment Patterns
Develop a SQL query that analyzes real estate investment trends by correlating n...
real estate investment urban development
Design
Global Street Art Cultural Movement
Design a SQL query to analyze global street art movements, tracking artistic sty...
street art cultural studies urban art
Education
Indigenous Knowledge Digital Preservation
Generate a SQL query to track and categorize indigenous knowledge systems, analy...
cultural preservation indigenous knowledge anthropology
Food
Microbrewery Recipe and Sales Optimization
Create a SQL query that correlates craft beer recipe variations, ingredient sour...
craft beer sales analytics brewing
Technology
Virtual Reality Gaming User Experience Study
Design a SQL query to analyze virtual reality gaming user experiences, tracking ...
virtual reality gaming user experience
Technology
Urban Public Transportation Network Analysis
Generate a SQL query to evaluate urban public transportation efficiency, mapping...
urban planning transportation data analysis
Entertainment
Esports Tournament Player Performance Tracking
Generate a SQL query to analyze professional esports tournament data, tracking p...
esports gaming analytics competitive gaming
Entertainment
Music Festival Attendee Demographic Insights
Generate a SQL query to analyze music festival ticket sales data, revealing atte...
music demographics event analysis
Entertainment
Immersive Theater Experience Analysis
Create a SQL query to track immersive theater audience experiences, measuring au...
immersive theater audience analytics performance art
Science
Urban Vertical Farming Innovation Tracking
Develop a SQL query to map urban vertical farming technologies, tracking innovat...
vertical farming urban agriculture innovation
Technology
Autonomous Vehicle Traffic Pattern Study
Create a SQL query to analyze autonomous vehicle traffic patterns, tracking navi...
autonomous vehicles transportation smart cities
Technology
Indie Game Development Ecosystem Analysis
Generate a SQL query to analyze the indie game development ecosystem, tracking g...
game development indie games market analysis
Science
Marine Ecosystem Biodiversity Monitoring
Create a SQL query to analyze marine biodiversity data, tracking species populat...
marine biology ecosystem tracking biodiversity
Science
Carbon Footprint Personal Tracking
Design a SQL query that calculates individual carbon footprint by integrating pe...
sustainability carbon tracking environment
Entertainment
Podcast Listener Engagement Metrics
Design a complex SQL query that tracks podcast listener drop-off rates, calculat...
podcast analytics media engagement
Business
Remote Work Productivity Assessment
Design a SQL query that analyzes remote worker productivity by correlating task ...
remote work productivity analytics
Education
Academic Research Citation Network
Create a SQL query to map academic research citation networks, identifying influ...
research academic citations network analysis knowledge mapping
Business
Customer Churn Analysis for SaaS Startup
Create a SQL query that identifies customers who have reduced usage by more than...
churn analytics saas customer retention
Science
Wildlife Conservation Research Tracking
Generate a SQL query for tracking endangered species population dynamics, monito...
wildlife conservation species tracking biodiversity
Education
Museum Artifact Preservation Tracking
Create a SQL query that maps artifact condition, restoration history, environmen...
museum conservation heritage
Lifestyle
Global Digital Nomad Movement Analysis
Develop a SQL query to track digital nomad trends, analyzing remote work locatio...
digital nomads remote work global trends
Science
Renewable Energy Grid Performance Analysis
Create a SQL query to analyze renewable energy grid performance, tracking solar ...
renewable energy grid performance data analysis
Science
Renewable Energy Grid Performance Tracking
Create a SQL query to analyze renewable energy grid performance, tracking energy...
renewable energy grid performance sustainability
Business
Sustainable Fashion Supply Chain Transparency
Develop a SQL query to track sustainable fashion supply chain metrics, analyzing...
sustainable fashion supply chain environmental impact
Health
Fitness Tracker Advanced User Segmentation
Develop a SQL query that segments fitness tracker users based on complex activit...
fitness data analysis user segments
Music
Global Music Streaming Regional Trends
Develop a SQL query that identifies emerging music genres by tracking cross-bord...
streaming music global trends
Health
Telemedicine Patient Outcome Prediction
Develop a SQL query that predicts patient treatment outcomes by analyzing medica...
healthcare predictive medicine technology
Health
Hospital Emergency Room Wait Time Analysis
Create a SQL query to analyze emergency room wait times, patient flow, and treatment efficiency.
healthcare performance metrics patient care
Entertainment
Film Festival Audience Engagement Analysis
Create a SQL query that tracks audience interaction across different film catego...
film analytics audience research
Business
E-commerce Customer Lifetime Value Analysis
Create a complex SQL query that calculates customer lifetime value by analyzing ...
e-commerce analytics customer value
Education
Alternative Education Model Tracking
Design a SQL query to analyze alternative education models, tracking student out...
alternative education learning models educational research
Science
Sustainable Agriculture Yield Optimization
Develop a SQL query that combines soil sensor data, crop rotation history, clima...
agriculture data modeling sustainability
Health
Precision Nutrition Personal Profiling
Generate a SQL query that creates personalized nutrition recommendations by anal...
nutrition personalized health data analysis
Business
Analyze Customer Churn in SaaS Startup
Generate a complex SQL query to identify potential customer churn for a SaaS pla...
customer analytics churn prediction SaaS metrics
Technology
Urban Mobility and Transportation Patterns
Design a SQL query to analyze urban transportation data, tracking ride-sharing u...
urban mobility transportation analytics smart city
Food
Global Microbrewery Collaboration Network
Develop a SQL query to map microbrewery collaboration networks, tracking beer re...
craft beer brewing collaboration
Entertainment
Indie Game Developer Success Metrics
Generate a SQL query that analyzes indie game development success by tracking re...
game development indie games analytics
Science
Community Garden Network Performance
Develop a SQL query to track community garden performance, including volunteer e...
community gardening urban agriculture social impact
Education
Cultural Heritage Preservation Tracking
Create a SQL query to map cultural heritage sites, tracking preservation efforts...
cultural heritage preservation historical research
Technology
Electric Vehicle Charging Network Analysis
Develop a SQL query mapping electric vehicle charging station usage, tracking re...
electric vehicles infrastructure sustainability
Education
Global Language Learning Platform Analysis
Generate a SQL query to evaluate online language learning platform effectiveness...
language learning edtech cultural education
Entertainment
Podcast Content and Audience Analysis
Create a SQL query to analyze podcast performance, tracking listener demographic...
podcast analytics content performance audience tracking
Business
Customer Churn Analysis in SaaS Startup
Create a complex SQL query that identifies potential customer churn by analyzing...
analytics customer retention database
Health
Tracking Rare Disease Epidemiological Patterns
Generate a SQL query that cross-references genetic markers, geographical cluster...
medical research epidemiology genetics
Science
Personal Carbon Footprint Tracking System
Create a SQL query to develop a comprehensive personal carbon footprint tracking...
sustainability carbon tracking personal impact