A collection of SQL solutions to analytics-focused coding problems practiced on NamasteSQL and other platforms.
Solving consistently to sharpen real world SQL and analytics thinking.
- SQL solution files for each problem
- Screenshots of the problem, query, and output
- Problems focused on analytics category
- CTE (Common Table Expressions)
- string_agg() for text aggregation
- CASE WHEN for categorisation
- Correlated subqueries
- GROUP BY with derived columns
- Window functions
- Date extraction and manipulation
- Joins and filtering
analytics/ → SQL solution files screenshots/ → Problem and output screenshots
- Database: PostgreSQL
- Primary Platform: NamasteSQL