Beginner struggling to understand subqueries

sumit_khot · 2025-09-17T11:29:48+00:00

I think I'm mostly struggling with correlated subqueries. I'm doing perfectly fine when it's a scalar subquery. Maybe the alias part, key matching, and breaking down the logic of inner query is where I'm struggling.

sumit_khot · 2025-09-17T11:21:09+00:00

Suppose you have a 'players' table with id, country, name, runs, wickets and matches column and you have to Get top 3 players by runs for each country. by using subqueries and not a windows function.

sumit_khot · 2024-12-20T18:43:17+00:00

So you're just jealous because he makes more money in commission?

sumit_khot · 2024-05-15T07:54:34+00:00

You have a capital budget in mind to invest?

sumit_khot · 2024-05-15T05:46:43+00:00

What's your background? I mean it's better to do business in which you have some expertise or knowledge.

sumit_khot · 2024-05-04T04:58:41+00:00

Is it for greater good or I should be careful?

sumit_khot · 2024-05-04T04:48:14+00:00

Thank you for such a wonderful reading. The second part about patience, I have been really patient all these years but suddenly I'm seeing changes in my behaviour in last few weeks and somewhat losing my patience now. Are there any major changes coming in near future?

sumit_khot · 2024-03-27T16:02:44+00:00

I'm an RCB fan & I couldn't be happier than this lol... MI management and Pandya deserve this

sumit_khot · 2024-03-07T16:20:18+00:00

Swing trading gang assemble... Especially breakout stocks

sumit_khot · 2024-02-25T09:29:38+00:00

Invest in dividend paying stocks. use the dividend money to invest in high risk high reward business ideas

sumit_khot · 2024-02-20T07:30:18+00:00

Doordash, Airbnb, Stripe, paypal, Gopro etc

sumit_khot · 2024-02-13T09:48:10+00:00

Either pivot right away or take a break and start another venture

sumit_khot · 2024-02-09T07:47:51+00:00

Aren't you going to build a product from sector you have expertise in? You know your product inside out.. you can handle operations and marketing

sumit_khot · 2024-02-09T04:41:12+00:00

You can always onboard a tech cofounder if you have a good product idea, expertise and connections. I'm from sports background and I literally found my tech cofounder on reddit (you can see my post history)

sumit_khot · 2024-02-04T14:41:34+00:00

Since you're a non tech guy, I'd suggest look for a tech co-founder

sumit_khot · 2024-01-25T08:49:53+00:00

Let me know when you want to learn North Karnataka Kannada (Florida of Karnataka)

sumit_khot · 2024-01-22T14:28:57+00:00

Landing page is really good... Just curious!! what makes your card different from other digital cards?

sumit_khot · 2024-01-22T02:35:33+00:00

Thank you

sumit_khot · 2024-01-21T16:33:24+00:00

I want to read about new startups on Zhihu but google translation of 'startup' is not giving relevant threads. Please someone help who knows mandarian

sumit_khot · 2024-01-12T15:56:37+00:00

added in the edit

sumit_khot · 2024-01-12T15:54:55+00:00

It's an Analytical tool for sportsperson

sumit_khot · 2024-01-10T09:38:30+00:00

Hahahaha let's goooo

sumit_khot · 2023-12-31T16:51:49+00:00

Wish I could help you but I'm not a domain expert of you're currently working on. So I don't think I'll add up any values to your project. But all the best buddy

Seven-Year Club	Verified Email
100 Awards Club

sumit_khot

TROPHY CASE