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
Education
Rare Book Collection Provenance Tracking →
Create a SQL query that maps rare book collection histories, tracking ownership ...
libraries book collection research
Technology
Urban Vertical Farming Optimization →
Design a SQL query to analyze vertical farming performance, tracking crop yields...
urban farming agriculture technology sustainability
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
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
Citizen Science Environmental Monitoring →
Generate a SQL query to aggregate citizen science environmental data, tracking p...
citizen science environmental monitoring community research
Finance
Urban Real Estate Investment Patterns →
Develop a SQL query that analyzes real estate investment trends by correlating n...
real estate investment urban development
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
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
Technology
Urban Transportation Demand Prediction →
Create a complex SQL query that predicts transportation demand by analyzing hist...
urban planning data analysis transportation
Science
Precision Agriculture Drone Mapping →
Create a SQL query to analyze agricultural drone mapping data, tracking field co...
precision agriculture drone technology farming
Technology
Urban Public Transportation Network Analysis →
Generate a SQL query to evaluate urban public transportation efficiency, mapping...
urban planning transportation data analysis
Design
Predictive Fashion Trend Forecasting →
Create a SQL query that predicts emerging fashion trends by analyzing social med...
fashion trend analysis market research
Education
Language Learning Platform Performance →
Create a SQL query that measures language learning effectiveness by tracking use...
language learning education technology analytics
Technology
Electric Vehicle Charging Network Analysis →
Develop a SQL query mapping electric vehicle charging station usage, tracking re...
electric vehicles infrastructure sustainability
Food
Global Food Delivery Platform Insights →
Create a SQL query analyzing international food delivery trends, tracking cuisin...
food delivery global trends economics
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
Education
Global Language Learning Platform Analysis →
Generate a SQL query to evaluate online language learning platform effectiveness...
language learning edtech cultural education
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
Education
Cultural Heritage Preservation Tracking →
Create a SQL query to map cultural heritage sites, tracking preservation efforts...
cultural heritage preservation historical research
Entertainment
Music Festival Attendee Demographic Insights →
Generate a SQL query to analyze music festival ticket sales data, revealing atte...
music demographics event analysis
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
Podcast Listener Engagement Metrics →
Design a complex SQL query that tracks podcast listener drop-off rates, calculat...
podcast analytics media engagement
Health
Fitness Tracker Advanced User Segmentation →
Develop a SQL query that segments fitness tracker users based on complex activit...
fitness data analysis user segments
Food
Restaurant Menu Optimization Strategy →
Generate a SQL query that identifies underperforming menu items by analyzing sal...
restaurant menu profitability analytics
Health
Precision Nutrition Personal Profiling →
Generate a SQL query that creates personalized nutrition recommendations by anal...
nutrition personalized health data analysis
Science
Climate Change Agricultural Impact →
Design a SQL query that correlates historical crop yield data with climate chang...
agriculture climate change data analysis
Science
Carbon Footprint Personal Tracking →
Design a SQL query that calculates individual carbon footprint by integrating pe...
sustainability carbon tracking environment
Entertainment
Indie Game Developer Success Metrics →
Generate a SQL query that analyzes indie game development success by tracking re...
game development indie games analytics
Technology
Virtual Event Engagement Metrics →
Generate a SQL query that comprehensively analyzes virtual event participation, ...
virtual events engagement analytics
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
Food
Global Microbrewery Collaboration Network →
Develop a SQL query to map microbrewery collaboration networks, tracking beer re...
craft beer brewing collaboration
Science
Marine Ecosystem Biodiversity Monitoring →
Create a SQL query to analyze marine biodiversity data, tracking species populat...
marine biology ecosystem tracking biodiversity
Entertainment
Podcasting Content Consumption Patterns →
Generate a SQL query to analyze podcast listening behaviors, tracking genre pref...
podcasting media consumption audio content
Science
Regenerative Agriculture Impact Assessment →
Generate a SQL query to track regenerative agriculture practices, measuring soil...
regenerative agriculture sustainability farming
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
Health
Mental Health Therapy Effectiveness Research →
Create a SQL query to analyze mental health therapy effectiveness, tracking pati...
mental health therapy research healthcare analytics
Entertainment
Immersive Theater Experience Analysis →
Create a SQL query to track immersive theater audience experiences, measuring au...
immersive theater audience analytics performance art
Food
Global Cuisine Recipe Innovation Tracker →
Generate a SQL query to analyze global recipe trends, tracking ingredient combin...
culinary trends recipe analytics global cuisine
Technology
Virtual Reality Gaming User Experience Study →
Design a SQL query to analyze virtual reality gaming user experiences, tracking ...
virtual reality gaming user experience
Entertainment
Esports Tournament Player Performance Tracking →
Generate a SQL query to analyze professional esports tournament data, tracking p...
esports gaming analytics competitive gaming
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
Education
Digital Learning Platform Performance →
Create a SQL query that analyzes online course engagement, learner retention, sk...
e-learning digital education analytics
Education
Academic Research Grant Performance Analysis →
Design a query that evaluates research grant effectiveness, tracking funding all...
research grants academic performance 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
Health
Telemedicine Patient Outcome Prediction →
Develop a SQL query that predicts patient treatment outcomes by analyzing medica...
healthcare predictive medicine technology
Technology
Electric Vehicle Charging Infrastructure Planning →
Design a SQL query to optimize electric vehicle charging station placement by an...
electric vehicles infrastructure urban planning sustainability
Travel
Personalized Travel Experience Recommendation →
Generate a SQL query that creates hyper-personalized travel recommendations by a...
tourism personalization data analysis
Business
Remote Work Productivity Assessment →
Design a SQL query that analyzes remote worker productivity by correlating task ...
remote work productivity analytics
Entertainment
Film Festival Audience Engagement Analysis →
Create a SQL query that tracks audience interaction across different film catego...
film analytics audience research
Science
Sustainable Agriculture Yield Optimization →
Develop a SQL query that combines soil sensor data, crop rotation history, clima...
agriculture data modeling sustainability
Technology
Autonomous Vehicle Traffic Pattern Study →
Create a SQL query to analyze autonomous vehicle traffic patterns, tracking navi...
autonomous vehicles transportation smart cities
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
Science
Community Garden Network Performance →
Develop a SQL query to track community garden performance, including volunteer e...
community gardening urban agriculture social impact
Music
Global Music Streaming Regional Trends →
Develop a SQL query that identifies emerging music genres by tracking cross-bord...
streaming music global trends