Tips for a sql assessment? What to review?

like
Posting as :
works at
You are currently posting as works at

Case when, Joins, date functions, window functions. I usually practice using leetcode easy and medium

like

Rank() lag() etc

CTE’s, window functions, conditional aggregations (e.g. sum-case)

Is this for a specific food delivery company?

If its for doordash I can confirm that you should know how to sum(case statement) and get proportions

like

Related Posts

Damn it! The end of HTGAWM. Such a great show it is! Gonna miss Viola Davis. Did you watch tonights finale?

like

My brother is looking to change his bank. Let it be any other bank or finance department in IT company.

Currently he is working in KVB in forex department.

What should be his plan to achieve this? LinkedIn is not working for him.

Any leads would be highly appreciated.

like

How common - or not - is it to make above 200k in recruiting? Is this just a golden carrot or pipe dream for most of us? I don't want to sell my soul, but I like what I do and would like to aim high. What is realistic?

like

I’m currently doing my first drug launch and wanted to ask if it’s normal to be working 15+hrs a day during a launch?

like

If anyone would like a CGI referral please direct message me. Happy to help.

like

Extremely confused with the hole “we are pro parents” stuff. Is it too awful to work from 9 to 5:30? Have two kids (6 and 8) and don’t want to loose special moments while they are little.

like

Before kids i was high-maintenance, but kids and EY made me tired exhausted woman, but I’m just 35! So i took a week off, kids are with my mom and I have a week to remedy. What could be my must haves for just one week. Haircut, mani pedi, massage is a must, but what else - want to do something for body and face - what are your favs? Want to wake up my sexy stunning woman locked inside mom and auditor.

like

DBS is hiring women who wants professional comeback/restart career.

DM me for referral

Post Photo
like

I've been trying to pivot to the consulting space for almost a year now, and just had no luck (partially because I need visa sponsorship). Anyone willing to help me with a referral? I have 3yr experience in FP&A and Corporate Strategy in financial industry

like

Australian fishies at Deloitte - when do we find out if we got promoted?

like

Has anyone started a non profit before? What is the process to register or the best way to get it set up legally?

like

Anyone help one of their parents go / initiate the separation and divorce process? VA is super sticky requiring a 6 months separation… but I’m just lost on what to do. Mother is being extremely difficult

like

Please guide me 🙏
Every opinion/guidance will be appreciated.

Tata Consultancy Infosys Capgemini Wipro Tech Mahindra Cognizant

Post Photo
like

Infosys Tata Consultancy Accenture IBM

Hi All, Can you please help me with 11 likes to get the acces for DM

likeuplifting

Salaries for hospital and/or pharmacy billing in Indianapolis area?

like

Y’all, anything good? In town for the next two days! Favorite experience or food? Tryna get cultured 🙏

like

See you all in...2021?

Post Photo
likefunny

What’s a good salary for a comfortable life in the SF area? Moving from NY to SF. At the strat Director level.

like

Women - do you wear Abayas to work daily?

like

Any difference between Tax Consultant I and II at Deloitte ?

like

Additional Posts in Consulting Exit Opportunities

Lets assume you want to go fully remote (read nomad) after EM at Mck and happy to take a 50% paycut for a better lifestyle- where would you look for freelance gigs/partime?

like

Well - this is probably PEAK FANG

Post Photo
like

Are product opps really better than consulting?

like

Got an offer from Baker Hughes for a senior role. Trying to understand how the work culture is, work life balance outlook and how are the benefits? How is the transition like from a big4 consulting to industry?

like

Does anyone actually love their job and the company they work for? Would love to hear how you found these opportunities

like

FAANG interview last wednesday. Was asked my availability for second round the next day to take place anytime tomorrow to next Tuesday. I sent it in ASAP but still no response. It’s been 6 days. Is there the possibility they cut the role/interview?

like

Is an fp&a manager role at a media company for 135k base + 10k bonus a good exit? 3.5 YOE

like

Which non-SWE roles are worth it at FAANG in terms of pay? Will any pay better than MBB?

like

Doing sport strategy work that’s very interesting with good wlb. Downside pay isn’t great relative to peers at other firms or exit opps that people are leaving for. Is it worth staying to finish project and in process receive a promo to consultant? Or should I start chasing the $?

like

Which FAANG companies have non-tech PM roles?

like

Why internal audit roles pay so poorly? :(

like

How much of a base comp cut would you consider to join an interesting tech startup?

like

What type of resumes do you all prefer to have - the modern funky/glossy attractive ones or the old ‘tried and tested’ reverse chronologically ordered one?

like

Anyone have a range for VP salary at Citi in their Consumer Card business?

like

Hi! I am looking for an exit from consulting. It’s an endless struggle to get on projects you actually like + the burden of meaningless initiative. Any leads for exit into Product Mgmt. at big tech?

like

Could anyone refer me to popular PE recruiting guides out there? Thank you and happy holidays!

like

Feeling gutted after being rejected in the final round of a very lengthy and grueling interview process. My stomach churns when I think of all the work I put in and how good of a fit the job was for me. Tips on getting past this?

like

Hi folks. I’m a data scientist at a T2/B4 firm that does fairly technical work. I am prepping for interviews to transition to SWE-data at a big tech company and currently have a little over 1 yoe.

Since prep usually takes a while for swe, I have not started seriously applying. However, I am likely to receive an offer for 110-120k at another consulting firm. I was hoping to get some thoughts from other technical folks that made the transition. More in comments

like

Which level in consulting opens the most exit opportunity doors? (C, SC, M, SM, etc)?

like

Aright folks. 30yo, done with consulting, and I’m ready to take my acting experience to the big screen. Any casting agencies want to refer me?? Also, seriously how do I find acting gigs in the DC area...

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal