Understanding Regular Expressions in Amazon Redshift: A Powerful Tool for Text Processing and Pattern Matching

Calculating Distinct Ids for Weekly Cohort in SQL: Improved Approach Using Window Functions

Getting Top Records per Category: Using Window Functions to Achieve Complex Queries.