Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "sql"

93 prompts matching "sql"

"sql" ✕ Clear all ✕
coding Advanced

Database Query Optimization with EXPLAIN Analysis

Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...

#coding #sql #database
👁 8 views
data Intermediate

Write a query that survives the source table being renamed in six months

I need to write a SQL query that pulls weekly metrics for a dashboard. The sourc...

#sql #data #query
👁 8 views
data intermediate

Write a metric definitions document that survives one analyst quitting

Act as a head of data preparing for an analyst's last day. I want the metric def...

#data #documentation #metrics
👁 8 views
data Intermediate

Write a SQL Query from a Plain-English Question

You are a SQL expert and data analyst. I will describe a question in plain Engli...

#data #sql #query
👁 8 views
data Advanced

Cohort Retention Analysis Framework SaaS Product Health

Act as a product analyst. Build a cohort retention analysis for [PRODUCT] using ...

#cohort analysis #retention #saas
👁 7 views
data Intermediate

Data Quality Audit Framework for New Source

Act as a data quality lead. I am onboarding a new data source: [SOURCE NAME], fo...

#data-quality #audit #validation
👁 7 views
data Advanced

Cohort Retention Analysis from Event Log

From the event log table with columns user_id, event_name, occurred_at, build a ...

#data #cohort #retention
👁 7 views
data Intermediate

Translate a Business Question into a Defensible SQL Query

You are an analytics engineer. I will paste a fuzzy business question (e.g., 'ho...

#sql #analytics #business-questions
👁 7 views
data Intermediate

Write and Explain a SQL Query

You are an expert SQL expert. Help me write a correct SQL query and understand e...

#data #sql #query
👁 7 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
data Advanced

Data: Write a SQL Query for a Cohort Retention Table

I want a SQL query that returns a cohort retention table — rows = signup month, ...

#data #sql #retention
👁 6 views
coding Advanced

Optimize a SQL Query for Speed

You are a database performance engineer. I will paste a slow SQL query and the t...

#coding #sql #database
👁 6 views
data Intermediate

Data: Rewrite a Slow Query Without Changing What It Returns

I have a SQL query that's slow. Make it fast while keeping the result set identi...

#data #sql #query-optimization
👁 5 views
coding Advanced

Coding: Write the SQL Index I Actually Need (Not the One I Think I Need)

I have a slow query and I'm about to add an index. Before I do, help me think it...

#coding #sql #performance
👁 5 views
data Advanced

Data: Write a Backfill Query That Won't Take Down the Database

I need to backfill [COLUMN/TABLE] with [LOGIC]. The table has [N] rows. Write th...

#data #sql #backfill
👁 5 views
data Intermediate

Write a SQL query to find customers who used to engage but have quietly dropped off

I want to find 'silently churning' customers — users who used to be active and h...

#data #sql #churn
👁 5 views
data Advanced

Rewrite a slow correlated subquery as a window function

I have a query with a correlated subquery that runs once per row to find each cu...

#SQL #window functions #query optimization
👁 5 views
data Intermediate

Build a SQL Style Guide That Survives a Growing Team

Act as a data platform tech lead. Write me a SQL style guide tailored to a 10-pe...

#sql #style-guide #dbt
👁 5 views
data Intermediate

Choose the right join before I merge two datasets

I have two tables I want to combine and I'll describe the key columns and what e...

#data #joins #sql
👁 5 views
data intermediate

Write SQL Queries from a Question

Act as a SQL expert. My tables are: [describe tables and key columns]. Write a S...

#data #sql #queries
👁 4 views
data Intermediate

Write and Explain a SQL Query From Plain English

Act as a SQL expert. I will describe what I want in plain English and you will w...

#data #sql #databases
👁 4 views
coding Advanced

Optimize a Slow Database Query

Act as a database performance engineer. Here is a slow query and its context: [P...

#coding #database #performance
👁 3 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval