Analyzing data one byte at a time

percent_rank, partition by, running sum

count distinct on multiple columns, lead/lag applications

self joins, using keyword in joins, dense_rank, rank

CTEs and 1 additional hack

Hacks as I learnt on Leetcode

Hey all, I have started SQL challenge on Leetcode and IT IS SO MUCH FUN! 10/10 recommend to anyone who is starting their datascience...

Things I learnt in 30-day coding Challenge and assignments

DML, DDL, DCL

All types of Joins, Sub-queries and Correlated sub-queries

Aggr functions, GROUP BY, Having clause

Basics, Select command, Logical operators and Wild card characters