Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "query"

108 prompts matching "query"

"query" ✕ Clear all ✕
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
👁 3 views
data Advanced

Write a SQL query that returns the right answer when the data has duplicates

I'm writing a SQL query against tables [paste schemas, especially the join keys]...

#sql #joins #duplicates
👁 3 views
writing Intermediate

Generate an SEO-Friendly Blog Outline from a Keyword

Act as an SEO content strategist. Given a target keyword that I provide, produce...

#writing #seo #blog
👁 3 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
👁 2 views
excel Intermediate

Reconcile two versions of a budget when the row labels don't match

You are an Excel modeler. I'll paste two budget extracts from different teams. T...

#reconciliation #budget #fuzzy-match
👁 2 views
excel Intermediate

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

#power-query #data-cleaning #pivot
👁 2 views
excel intermediate

Clean Messy Excel Data Step by Step

Act as a data cleaning specialist. My Excel sheet has these issues: [list proble...

#excel #data cleaning #power query
👁 2 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
👁 2 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
👁 2 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Advanced

Plan an Excel Macro or Office Script

You are an Excel automation expert. I will describe a repetitive task and you wi...

#excel #automation #vba
👁 2 views
excel Intermediate

Clean Messy Spreadsheet Data Step by Step

You are a data-cleaning specialist. I have a messy Excel sheet with these proble...

#excel #power-query #data-cleaning
👁 1 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
👁 1 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval