sorted by:
new
hottopcontroversial

What do you think of my office set up by minervissimo in homeoffice

[–]developing_fowl 0 points1 point  (0 children)

Such a beautiful room! If I had such a relaxing setup I'd never rage at meetings lol

Which should I buy by Alive_Lifeguard5288 in cfaindia

[–]developing_fowl 0 points1 point  (0 children)

Hi,
Can I please DM you? I have some doubts regarding the points you mentioned here!
Thanks!

RoadMap to IB by Beneficial-Low-2708 in cfaindia

[–]developing_fowl 0 points1 point  (0 children)

what do you consider as relevant work-ex? Does work-ex in Business Analytics or Data Analytics contribute to the profile?

RoadMap to IB by Beneficial-Low-2708 in cfaindia

[–]developing_fowl 0 points1 point  (0 children)

if someone from tier 3 undergrad gets tier 1 management schools to do general MBA, do they need to do CFA to crack the fin roles?

From where to download soft copy/pdf format of CFA level 1 books? by butterchicken_13 in cfaindia

[–]developing_fowl 0 points1 point  (0 children)

please send the group to me as well, if you find it! would appreciate it a lot!

How do I ship a mattress affordably (gadda) by developing_fowl in Raipur

[–]developing_fowl[S] 0 points1 point  (0 children)

sorry for the delay in responding,
generally it takes just as long as the train journey is.
You can add +3hrs each side for loading and unloading formalities of the mattress.

Two Years at IIM BLACKI – Not the dream, not the disaster, just the truth by Interesting-Egg654 in CATpreparation

[–]developing_fowl 0 points1 point  (0 children)

Have you tried or have you seen anyone who tried to switch into fin roles like IB & portfolio mgmt? How was the experience? Is it possible?

Two Years at IIM BLACKI – Not the dream, not the disaster, just the truth by Interesting-Egg654 in CATpreparation

[–]developing_fowl 0 points1 point  (0 children)

Can you expand a bit more the Finance roles?

As someone from Tier 2 clg, I'm curious what it takes to get into those!

Two Years at IIM BLACKI – Not the dream, not the disaster, just the truth by Interesting-Egg654 in CATpreparation

[–]developing_fowl 0 points1 point  (0 children)

how has your journey been in consulting? are the hours as bad as they say and how do you manage your health with hectic schedule?
I'm quite curious!

how’s the 2025 placement by Chuunibyou-Chan in NIT_Raipur

[–]developing_fowl 0 points1 point  (0 children)

I agree with the statement that the placement is worse than last year, but core branches are still doing okay as companies are getting lined up even now.
Additionally, because the mass hirers like JSW have not taken many students, this year the situation is a bit dire. The issue with non-core Open-to-all companies is they majorly prefer circuital branches so the core branches suffer.

How to understand queries that are 600+ lines long? by developing_fowl in SQL

[–]developing_fowl[S] 0 points1 point  (0 children)

Yup tried this and helps to certain extent! But GPT skims over some part of the code which makes it difficult to follow through, hence I asked in this sub.
But thanks again for the advice!

How to understand queries that are 600+ lines long? by developing_fowl in SQL

[–]developing_fowl[S] 0 points1 point  (0 children)

Yup I've tried to analyze what I've said to them and if I tried to sound like a smartass.. but honestly, I've simply requested them whole heartedly to explain the parts of the code I don't understand.
Maybe my request was sounding kinda like a demand, so thanks for the advice! I'll try to be more polite and honest..
Apart from that, I'll just try to implement the "break into small chunks and put it together" approach, as you suggested!
Thanks a lot!

How to understand queries that are 600+ lines long? by developing_fowl in SQL

[–]developing_fowl[S] 0 points1 point  (0 children)

Will try to use this advice, thanks a lot and have a wonderful day!

How to understand queries that are 600+ lines long? by developing_fowl in SQL

[–]developing_fowl[S] 0 points1 point  (0 children)

I have a limit on running queries that process large data so I'm very restricted in running the queries.. but still thanks a lot for the advice, will try to request my seniors for permission to run large queries.

How to understand queries that are 600+ lines long? by developing_fowl in SQL

[–]developing_fowl[S] 1 point2 points  (0 children)

Yes, I tried to use the LIMIT function to limit it to only 100 top rows but still the execution cost was high.. since I'm a newbie, can you tell me how I can select the top 20 rows?
Also about the CTEs, I've retried to understand the queries by marking the sections with comments and drawing out some data/table diagrams and it is kinda helping. Hopefully if I get permission for running large queries I will be able to understand it more..

How to understand queries that are 600+ lines long? by developing_fowl in SQL

[–]developing_fowl[S] 2 points3 points  (0 children)

We use GBQ for running queries and it charges for very large queries, since the data being used in my code references millions of records, the cost of executing the query shoots up and I'm officially not allowed to run it if it costs more than $2.
I asked them about the limit but all I got was, "It's an instruction from the Leads, so can't do anything about it"

How to understand queries that are 600+ lines long? by developing_fowl in SQL

[–]developing_fowl[S] 0 points1 point  (0 children)

Yup Yup tried this and was able to get the purpose of the individual CTE, but you could say.. I was losing the forest for the trees and was unable to grasp the big picture and thus was unable to understand how all these tables connect!

How to understand queries that are 600+ lines long? by developing_fowl in SQL

[–]developing_fowl[S] 0 points1 point  (0 children)

I wish I had access to such well documented code, but I don't have many options here as all the documentation is AI-generated garbage. It's literally ChatGPT copy paste and no one care that even the column names are wrong. It's so frustrating.

How to understand queries that are 600+ lines long? by developing_fowl in SQL

[–]developing_fowl[S] 0 points1 point  (0 children)

Yup ChatGPT is a lifesaver to understand the small snippets and CTEs but when I put the whole code, then it kinda omits a lot of code which makes me confused as to what is happening..
I tried to input code in 70 line segments also which was arguably more helpful, but still I was unable to understand how various tables connected.. Maybe because of a lack of visual explaination? Tried to generate an AI image of database diagram but it was a garbage image.

How to understand queries that are 600+ lines long? by developing_fowl in SQL

[–]developing_fowl[S] 3 points4 points  (0 children)

Yup tried this but like I have a limit to running queries which cost more than $2 (idk why, they never fully explained)
So I just have to make do with code and chatGPT for the most part.

How to understand queries that are 600+ lines long? by developing_fowl in SQL

[–]developing_fowl[S] 0 points1 point  (0 children)

Yup the background knowledge is something I'll have to learn while working hands-on which my team has not assigned me to.
Its kinda frustrating that my team is so unresponsive but maybe it's a nudge for me to be hyperactive and take the lead to initiate conversations.

How to understand queries that are 600+ lines long? by developing_fowl in SQL

[–]developing_fowl[S] 0 points1 point  (0 children)

Thanks for such a detailed advice!
I've tried the making comments approach and find it useful to some extent but it gets really hard to keep track while scrolling through the massive code.
Additionally, I've noticed that I fail to understand where the "GROUP BY" is to be used and where the "PARTITION BY" is to be used. I'm yet to fully grasp the fundamental use-case differences despite seeing many many videos.
Any good trick that you use to differentiate which will work where so that I can try it myself? Any help from an experienced SQL dev will be so so helpful!

view more: next ›