This is literally my new workflow now:
Real-time research/search → Grok 4
Planning & Reasoning → Grok 4 Heavy
Coding → Claude 4 Sonnet w/ Claude Code
Write Test Cases → Gemini 2.5 Pro
Run Test Cases → Codex
Debug → o3
Bookmark this.
Mr Ajay, an NRI client at TaxBuddy sold ₹7 Cr worth of inherited property
We gave him 4 options to save taxes
He ended up paying ZERO tax. Here's all about those 4 options🧵👇
SQL has levels to it:
- level 1
SELECT, FROM, WHERE, GROUP BY, HAVING, LIMIT
Master these basic keywords and you’ll be well on your way to mastering SQL.
- level 2
Mastering JOINs:
Most common JOINs: INNER and LEFT
Less common JOINs: FULL OUTER
Joins you should avoid almost always: RIGHT and CROSS JOIN
Mastering common table expressions (CTEs).
The WITH keyword defines a CTE which you can imagine as a “variable” that you can query later.
Using variables like this you can master algorithm techniques like recursion, breadth first search and more!
CTEs also make your SQL much more readable and make your coworkers hate you less compared to nested sub queries.
- level 3
Mastering window functions
Window functions have 3 pieces:
The function (i.e. SUM, RANK, AVG)
The over clause to start the window
The window definition which has 3 pieces:
- how to split the window up with PARTITION BY
- how to order the window with ORDER BY
- how to restrict the window size with ROWS clause (useful for rolling monthly averages)
Understand RANK vs DENSE_RANK vs ROW_NUMBER, I have been asked this in interviews a million times.
- level 4
You understand table scans, b-tree indexes, and partitioning schemes to increase performance.
Doing something like COUNT(CASE WHEN) is much better than doing multiple queries with a UNION ALL. UNION ALL is terrible for all sorts of reasons that I don’t want to get into in this post.
B-trees indexes allow for efficient scanning of data in the WHERE clause.
Use explain plans to understand if an index is actually being used or not!
Partitioning is similar to indexes except it’s a “poor mans” index. It just keeps data in specific folders and skips the folders that don’t include the data I question.
What else did I miss for mastering SQL?
I haven't got any reward points since Aug 20th.I've done multiple transactions on my Axis Indian Oil credit card including fuel transactions at Indian Oil pumps. Last month also I had to tweet for not getting reward points.What's wrong with you @AxisBank@AxisBankSupport
@NeverSayYesDude Lol did you read his statements completely? Please pay attention to" riding on the wrong side". it was not about carrying children on a scooter
🚀🌟 Can this penny stock skyrocket to 10x or crash to zero? 💥
Profit Growth: 7000% 📈
6-Year Breakout 🔥
Lifetime High Volume 📊
📌 Retweet, Comment, & Follow to get the stock name in your DMs! 💬
🔗𝐉𝐨𝐢𝐧 𝐨𝐮𝐫 𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦 : https://t.co/v1Jgxz3jsS
🌟🚀Can this stock become X3! 💫
💰✨ CMP:156 || MY TARGET 🎯 400+✨
🚨6 Year Breakout with Huge volume
📌Retweet ,Comment & Follow to get stock name in your DM
🔗𝐉𝐨𝐢𝐧 𝐨𝐮𝐫 𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦 : https://t.co/v1Jgxz3Riq
@AxisBankSupport@AxisBank@RBI@RBIsays I still haven't received the reward points for the transactions I have done for the last 1 month or so.Please don't advertise the benefits of your credit card when in reality you have failed to give the rewards.
@AxisBank@AxisBankSupport I haven't received any reward points since July 10th.I've done multiple transactions on my Axis Indian Oil credit card including fuel transactions at Indian Oil petrol pumps. Please look into the issue and resolve ASAP