93 prompts matching "SQL"
You are a SQL teacher. Walk me through window functions using realistic examples...
Write SQL queries for a business intelligence dashboard. Tables: orders, custome...
Write SQL queries for a database with tables: orders (id, customer_id, order_dat...
Design an optimized database schema for my web application. Requirements: Appli...
Act as a senior database architect. Design a normalized database schema based on...
Help me perform customer segmentation using the RFM (Recency, Frequency, Monetar...
Write a SQL query for weekly active user reporting from this schema: [paste tabl...
Act as a senior data engineer and SQL expert. Help me master SQL window function...
Write SQL for a cohort retention analysis and explain how to visualize it. Cont...
Act as a sales operations analyst. I have a messy CRM export that I want to clea...
Act as a data analyst. I have sales data with columns: Date, Product, Category, ...
Review my SQL query before I use it in an executive or board report where mistak...
Analyze this SQL query for performance issues: [QUERY]. Provide: execution plan ...
Write a SQL stored procedure in [MySQL / PostgreSQL / SQL Server] for the follow...
Help me optimize this slow SQL query: [paste your query]. The database is [MySQL...
Design an ETL (Extract, Transform, Load) pipeline for loading data from [source ...
Design a normalized relational database schema for a multi-vendor e-commerce pla...
Act as a database performance engineer. I will paste a slow SQL query and its EX...
You are a product data analyst. I need help analyzing subscription retention by ...
Act as a senior SQL analyst. I need SQL that compares this month versus last mon...
Create a comprehensive code review checklist for [language: Python/JavaScript/Ty...
Write a safe Postgres migration for a 50M-row production table (heavy write traf...
Write a Postgres query to produce a monthly cohort retention table. Source table...
Help me refactor a slow SQL query so it runs faster without changing the busines...