DAY 55 of learning SQL #100daysoflearningSQL

Day 37/100 of SQL Learning 📌 Today, I learnt about Materialized Views a type of view that’s quite different from regular views. Even though MySQL Workbench doesn’t support them, I still took time to understand the logic and syntax behind how they work. #100daysoflearningSQL

Day 29 of SQL learning: No queries today, just real-life problems Thinking through when to use: - ROW_NUMBER() - NTILE() - LAG() & LEAD() - RANK() & PARTITION BY - Moving averages with OVER() Slowly connecting the dots! #SQL #DataLearning #100daysoflearningSQL