Search: "LET function"

SQL Query - Complex Joins and Aggregation

Write SQL queries for a database with tables: orders (id, customer_id, order_dat...

#coding #SQL #joins

#delegation #task management #leadership

productivity Advanced

Delegation Framework and Task Brief Template

Create a delegation system that helps me hand off work effectively. My role: [y...

customer-service Beginner

Customer Service Email Templates for 10 Common Scenarios

Act as a customer service manager. Write professional, empathetic email response...

#customer service #email templates #support

#board-meeting #governance #pre-read

business Advanced

Board Meeting Pre-Read Document Generator

Act as a chief of staff to a startup CEO. Draft a board pre-read for the [QUARTE...

#lambda #custom-functions #excel

excel advanced

Excel LAMBDA Custom Functions for Business Calculations

Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...

👁 20 views

coding advanced

SQL Window Functions: Advanced Analytics Query Guide

Act as a senior data engineer and SQL expert. Help me master SQL window function...

#coding #sql #window-functions

👁 20 views

data Intermediate

Pandas Cleanup Pipeline for a Messy Real-World CSV

Below is a sample of a messy CSV (10 rows shown). Build a pandas cleaning pipeli...

#data #pandas #csv

👁 20 views

creative intermediate

Character Development Arc: Transformation Story Template

Act as a story development coach and narrative structure expert. Help me design ...

#creative #character #development

👁 18 views

#python #unit tests #pytest

ChatGPT prompt for generating Python unit tests for an existing function

Act as a senior Python test engineer who follows best practices for pytest. I h...

👁 17 views

creative Beginner

Children's Story with Moral Lesson and Illustrations Guide

Write an original children's story with the following specifications: - Target ...

#children story #picture book #storytelling

#email #networking #follow-up

email Beginner

Networking Follow-Up Email After a Conference or Event

Write 3 variations of a networking follow-up email to send within 48 hours after...

#code review #security #performance

coding intermediate

Code Review Checklist: Security, Performance, and Maintainability

Create a comprehensive code review checklist for [language: Python/JavaScript/Ty...

#dynamic arrays #FILTER #SORT

excel Intermediate

Excel Dynamic Arrays: FILTER, SORT, and UNIQUE Functions Mastery

Help me master Excel dynamic array functions to replace my manual filtering and ...

#code review #pull request #software engineering

ChatGPT Prompt: Code Review Checklist Tailored to PR Diff Analysis

Review this pull request diff and provide structured feedback. [PASTE DIFF OR F...

#coding #refactoring #clean-code

Refactor a God Function with Multiple Responsibilities

Below is a function that's grown to ~200 lines and does too much. Refactor it. R...

data Advanced

SQL Window Function to Find Customer Churn Cohort by First-Purchase Month

Write a Postgres query to produce a monthly cohort retention table. Source table...

#data #sql #postgres

#coding #code-review #pull-request

coding intermediate

Code Review Checklist for Pull Requests

Generate a comprehensive code review checklist for pull requests in a [language/...

#finance #investing #portfolio

finance intermediate

Investment Portfolio Rebalancing Strategy Template Guide

Create a comprehensive guide for individual investors on portfolio rebalancing s...

#business #startup #investor-update

business Intermediate

ChatGPT Prompt: Investor Update Email Template for Seed-Stage Founders

You are an experienced founder writing a monthly investor update. Help me draft ...

#coding #testing #property-based

coding Advanced

Generate Property-Based Tests with Hypothesis or fast-check

I have a function `[paste signature + 1-paragraph spec]` and I want property-bas...