96 prompts matching "function"
You are a SQL teacher. Walk me through window functions using realistic examples...
Write a nested IF formula in Excel that assigns letter grades based on numeric s...
Act as a senior data engineer and SQL expert. Help me master SQL window function...
Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...
Act as an Excel expert. I need a formula that flags duplicate customer rows wher...
Below is a sample of a messy CSV (10 rows shown). Build a pandas cleaning pipeli...
Act as a senior Python engineer. Write a function {{function_name}} that {{descr...
Write SQL queries for a database with tables: orders (id, customer_id, order_dat...
Act as a story development coach and narrative structure expert. Help me design ...
Act as a chief of staff to a startup CEO. Draft a board pre-read for the [QUARTE...
Below is a function that's grown to ~200 lines and does too much. Refactor it. R...
Act as a senior Python test engineer who follows best practices for pytest. I h...
Teach me SQL window functions with practical business analytics examples. Cover:...
Create a comprehensive code review checklist for [language: Python/JavaScript/Ty...
Create a comprehensive guide for implementing Excel data validation with dropdow...
Create a comprehensive guide for individual investors on portfolio rebalancing s...
Create a TypeScript utility functions library with these categories: 1) Array ut...
Help me write and structure a song. Genre: [pop / country / R&B / folk / rock]. ...
Help me master Excel dynamic array functions to replace my manual filtering and ...
Design a library of reusable custom Excel functions using the LAMBDA function fo...
Review this pull request diff and provide structured feedback. [PASTE DIFF OR F...
Write a Postgres query to produce a monthly cohort retention table. Source table...
Refactor the following legacy JavaScript code to modern ES2024 standards: [PAST...
Create Excel formulas for: [DESCRIBE TASK]. Include: the formula, explanation of...