Biweekly Contest 194
Solved Q1: Difference Between Peaks and Valleys
O(n) time, O(1) space.
Tried Q3: Count Magical Substring Pairs I, but my nested-loop approach needs optimization.
TLE is the worst nightmare. Back to optimizing and learning.
#LeetCode#DSA
Day 1 of SQL Revision
Today’s revision: CTEs (Common Table Expressions)
Breaking complex queries into readable steps using WITH.
Revisiting aggregations, department averages, and salary percentages.
Using CTEs with joins to simplify SQL logic.
#SQL#100DaysOfCode#WinterArc