window-function-builder
CommunityMaster SQL window functions.
Data & Analytics#query optimization#data analysis#business intelligence#sql#window functions#ranking functions
AuthorNir-Bhay
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill helps users understand and construct complex SQL queries involving window functions, crucial for advanced data analysis and business intelligence.
Core Features & Use Cases
- SQL Window Function Expert: Provides syntax, examples, and best practices for ranking, aggregate, offset, and statistical window functions.
- Business Analytics Patterns: Demonstrates practical applications in customer lifecycle analysis, cohort analysis, sales performance, and inventory management.
- Platform-Specific Examples: Includes syntax variations for PostgreSQL, SQL Server, BigQuery, and Snowflake.
Quick Start
Use the window-function-builder skill to generate an SQL query for calculating the 7-day moving average of daily revenue.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: window-function-builder Download link: https://github.com/Nir-Bhay/markups/archive/main.zip#window-function-builder Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.