sql-queries-window-functions
About
This skill provides a reference for SQL window functions, enabling developers to perform advanced analytical queries without leaving their workflow. It covers essential patterns like ranking, running totals, and comparing rows with LAG/LEAD. Use it when you need to write complex data analysis queries that operate over partitions of result sets.
Quick Install
Claude Code
Recommendednpx skills add vamseeachanta/workspace-hub -a claude-code/plugin add https://github.com/vamseeachanta/workspace-hubgit clone https://github.com/vamseeachanta/workspace-hub.git ~/.claude/skills/sql-queries-window-functionsCopy and paste this command in Claude Code to install this skill
GitHub Repository
Related Skills
data-warehouse-designer
OtherThis skill designs dimensional models and fact tables for data warehouse projects. It clarifies requirements, reviews system constraints, and selects appropriate architectural patterns. The outputs include implementation plans, specifications, and validation steps for developers.
data-catalog-creator
OtherThe data-catalog-creator skill helps developers design and plan systems for managing metadata, data lineage, and discovery. It generates implementation plans, architectural specs, and required artifacts based on your stack and constraints. Use this skill when you need to establish or improve data governance, compliance, and discoverability within your infrastructure.
data-pipeline-builder
OtherThe data-pipeline-builder skill designs and plans orchestration pipelines with a focus on idempotency. It's used when you need to create data workflows, producing artifacts like specs, configs, and validation steps. Developers should use it after confirming requirements and necessary approvals.
data-quality-framework
OtherThis skill helps developers implement data quality checks through validation, profiling, and anomaly detection. Use it when you need to design or plan a data quality system within a given architecture and stack. It guides you from clarifying requirements to producing implementation artifacts and acceptance criteria.