Search: "explain"

coding Intermediate

Generate a SQL Migration With Safe Rollback

Act as a database engineer. Write a {{database: e.g., PostgreSQL 15}} migration ...

#coding #sql #migration

#data #sql #window-functions

data Advanced

Write Window Functions That Replace a Subquery Loop

Act as a senior SQL engineer. I need to compute {{describe: e.g., 7-day rolling ...

writing Intermediate

Generate Compelling Book Chapter Opening Hooks

I'm writing a [GENRE] novel. The chapter I need a hook for has this premise: [CH...

#book #fiction #opening

#A/B testing #sample size #statistical significance

data Intermediate

A/B Test Sample Size Calculator and Analysis

Help me plan and analyze an A/B test: **Planning Phase:** - Current conversion ...

#creative #world building #fiction

creative Intermediate

World-Building Bible for Fiction Writing

Act as a world-building consultant for fiction writers. Help me create a compreh...

#excel #xlookup #index match

excel Beginner

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

#tutoring #error analysis #guided questions

education Intermediate

ChatGPT Prompt for Explaining a Mistake Without Giving Away the Answer

Help me tutor a student by explaining their mistake clearly without immediately ...

#code review #debugging #quality

Coding Advanced

Code Review Assistant

Review this code for: bugs, security issues, performance optimizations, code sty...

customer-service Intermediate

ChatGPT prompt for resolving customer billing dispute with empathy and policy compliance

Act as a billing support specialist trained in both empathetic communication and...

#customer service #billing #dispute

#creative #campaign #product launch

creative Advanced

Creative Campaign Concept for Product Launch

Develop a creative campaign concept for launching [product name], a [product des...

#postgresql #indexing #performance

coding advanced

PostgreSQL Database Indexing Strategy for Slow Queries

Analyze and fix slow query performance in PostgreSQL for [describe your schema a...

#ab-testing #statistics #analytics

A/B Test Analysis Statistical Significance Calculator Guide

Walk through a complete A/B test analysis for [experiment, e.g., testing two ema...

#data #machine-learning #model-evaluation

Machine Learning Model Evaluation and Selection Framework

You are a machine learning engineer and data scientist. I need to evaluate and s...

Database Indexing Strategy & Query Performance Optimization Guide

Help me optimize my database performance through indexing. My context: Database...

#database #indexing #sql

#coding #sql #performance

coding Advanced

SQL Query Optimizer With EXPLAIN Plan Walk-Through

I have a slow SQL query against [DB ENGINE — Postgres / MySQL / SQL Server]. The...

#duplicates #data cleaning #excel

excel Intermediate

Excel Formula to Detect Duplicate Records Across Columns

I need an Excel formula to detect duplicate records based on a combination of mu...

#memory leak #nodejs #debugging

coding Advanced

Debug Memory Leak in Long-Running Node.js Process

I have a Node.js process leaking memory. RSS grows from 200MB to 2GB over 6 hour...

#education #Feynman #lesson plan

education Intermediate

Design a Lesson That Uses the Feynman Technique

Design a 45-minute lesson on [TOPIC] for [AGE/LEVEL] using the Feynman technique...

customer-service Intermediate

ChatGPT prompt for building canned replies for refund policy questions

Act as a support operations manager. I need a reusable set of canned replies for...

#refund policy response #canned replies #customer support macros

customer-service Beginner

ChatGPT Prompt for Support Reply That Calms a Frustrated User Fast

Write a customer support reply that quickly calms a frustrated user while moving...

#support response #customer complaint #de-escalation

#excel #vlookup #index-match

excel beginner

VLOOKUP vs INDEX-MATCH: Smart Data Lookup Formulas

I need to retrieve data from a lookup table in Excel. My main table has [column ...

#email #deadline #negotiation

email Beginner

Professional Email to Negotiate a Deadline Extension

Write a professional email to my manager or client requesting a deadline extensi...

#SQL #window functions #analytics

SQL Window Functions Advanced Analytics Queries

Teach me SQL window functions with practical business analytics examples. Cover:...