Hi - I am prepping for a S&O associate role at Google. And the HM said there will be live SQL case study. Can anyone please help with what kind of questions to expect and how difficult the SQL interview would be? Any help would be appreciated. Thanks!

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

Expect using JOINS. Not hard tbh. You can ramp up to the level needed in 1-2 days from 0

like

Great thanks so much! Any thoughts on how many questions in the interview…and if it is like a progressive case study (like 4-5 questions with increasing difficulty)? TIA

This is what ChatGPT says: 😉

You’re typically given:
• A problem statement (e.g., user growth, churn, abuse detection, funnel performance)
• 1–4 tables (users, events, transactions, logs, etc.)
• A set of questions that increase in complexity

You may be asked to:
• Write SQL queries
• Explain assumptions
• Interpret results
• Propose follow-up analyses

Example (simplified)

Scenario
A messaging product wants to understand whether a new feature increased engagement.

Tables
• users(user_id, country, signup_date)
• messages(message_id, user_id, sent_at, is_business)
• events(user_id, event_type, event_time)

Questions
1. How many daily active users sent at least one message last week?
2. Compare engagement before vs after feature launch.
3. Break results down by country.
4. Identify any data quality or bias risks.

You’d be expected to:
• Join tables correctly
• Filter by time windows
• Use GROUP BY, COUNT(DISTINCT …), maybe window functions
• Explain why your query answers the question

What level?

L4 Senior associate

Hey EY 🐟 , congratulations on getting the interview. Mind telling a bit more about your profile ? I am applying for S&O and have been targeting the L5 level

Any updates? Did you pass the first round?

Related Posts

What are the tldr differences between HR roles, people Operations, and people business partner positions? They all seem similar but I’m curious how y’all characterize them. I’m coming out of a very internal position at a nonprofit and I’m trying to better align my work accomplishments to make sense in more traditional career paths.

like

What is the best way to search for remote job openings in the IT sector in Canada provided you already have a PR and everythg is legal

like

Do you still write thank you emails after interviews? A lot of the roles I interview for these days are coordinated by recruiters so I don’t see the interviewers emails

Hi Big 🐟,

Can somebody refer me into EXL services, As I have got shortlisted on Job ID 568888 but getting no response from their side. It will be more convenient to go through the interview process.
As well I'm looking for a change into O2C(Billing, Cash Application & Contract Management). I have 5 years of experience in the accounting & auditing field.

like

LTI is Hiring for below Cloud/DevOps BU Positions!!

Immediate to 30 days joiners will be preferred ..

Interested plz DM with job codes to apply

Post Photo

Hi Guys, I'm looking to switch my job but not getting any calls since last couple of months. Can anyone please refer me ?
Current position - QA Engineer
YOE - 4+ yrs
Notice Period - 60 days
Preferred location - Pune, Bengaluru, Remote
Tech Skills - Postgre sql, Python, software testing, manual testing.
JIRA, Bugzilla, Postman API, Katalon, Zephyr.
Regression testing, black box testing.

like

Hi Fishes,

Looking for a job referral for Production Support L2/L3 role.
I have 6 years of experience.

Do let me know if any openings.

like

Can anyone please refer me for the role of SAP ABAP developer.
Yoe - 6.3

like

Anyone have great success applying to jobs they are not sure they qualify for on USAjobs?

like

I have an interview with Korn Ferry for an associate principal role and am curious about others’ experiences have been with work-life balance here. Also, I have an idea of what I should be compensated in this type of role, but any insights on how they pay compared to others would be helpful. Are you traveling during the pandemic or have client interactions been virtual? Lastly, if you are a consultant here, are you on billable hours? My current consulting role is not - so this would be new.

like

Amazon recruiter reached out and wants to know my general compensation expectations before first interview. Very little info available on role but seeing $150k-$250k total compensation reported. Is this too wide of a range to give them?

like

Are unpaid 90+ minute blind skills assessments normal procedure before an interview is scheduled ?

like

Hello fellow introverts! How is 2022 treating you all so far? I am eagerly seeking for an exit out of consulting :)

like

Hiring for an Associate Data Director to join our team at Chiat LA! Role would lead Data Strategy on a couple key accounts with support, working side by side with strategy and creative teams throughout the entire creative process. 7+ years and management experience preferred.

Thanks - please feel free to reach out if interested!

likefunny

Hi all! I'm new to Fishbowl and a recent college graduate. I'm looking for a full-time role once my summer internship ends and I'd appreciate help in finding some openings.

I have experience in pharmaceutical advertising (account services) and the publishing industry (editorial). I'm looking to work at a company I can utilize my passion for writing and account experience. Maybe public relations or corporate communications? I'm up for anything!

I appreciate any suggestions that come my way! :)

like

Hey Fishes,

We are hiring!!!

Kindly drop a text/ email id if you are keen.

Wipro

Post Photo
like

Hey fishes

Can anyone give me referral?
Thanks!

like
like
like

I've been corp healthcare for 20 yrs and am planning an exit in 6 months to open a legal/consulting business. Looking for thoughts on billable hourly for law firms/ providers/healthplans as clients.

like

More Posts

Anyone from accenture capability network in sap s4? Please dm or comment. I have some doubts

like

Biggest cons of vending machines?

like

Which firms focus on customer experience strategy and more marketing, product, market expansion focused projects? To some degree to all firms have this focus?

like

Quaker City in Philly is looking for an Account Manger. Great opportunity for anyone intesrted in branding / spirit brands.

Post Photo
like

Hi All,

I joined Sunlife on 29th Nov. Till now I didn't hear back from anyone. Not sure about if my laptop is dispatched or now.

I'm living in Bangalore and will be working from here only.

Can someone please guide me, what I need to do?
Given contacts are not helpful.

What is the official vacation announcement for EY during 4th July weekend?

Any tips on studying for BCPS without residency, just several years of hospital experience?

like

That moment when you realize you did not press Ctrl-s and kept working on your excel sheet for hours 💻 📊

And then.. *drumroll*

it effing CRASHES...!!! #FMFL

🤦🏻‍♂️😖😣😡😤😩😫

like

someone doesn't give af

like

Is it true that lateral hire BAs at Mck get 145 base?

Virtual mock draft. 12 teams. (You put down your pick number (e.g. 1.12), player name, optional commentary why you picked him)

like
like

Does anyone have any career insight for a tax associate in corp dev? Is it as lucrative as regular corp dev? What do you do on a day-to-day basis?

like

Does anyone have experience in SIOP in Supply Chain? What organizations do it and can explain how you use it for work?

like

Hello guys, where can i find discount for universal studio Halloween horror night tickets ?

like

What is the CTC tht one with 14 yoe can expect in Globant if being hired for Senior Project manager position ?

How much should a TV producer be paid a year? I've been working as a digital producer for 2 years now and I've been traveling for the last 4 years, so I'm not sure what would be a fair payment in the US for a TV producer. Any comment will be extremely helpful.

like

Can anyone here refer me to IBM?

like

Bain & Company Hi, can anyone help me with (1) the salary bands for ‘Associate consultant’, ‘Senior Asc consultant’ to ‘Consultant’? (2) where does the ‘Junior consultant’ role offered at ISB fall in the hierarchy? (3) A graduate with 4Year work experience would be eligible for which role out of the above? Bain & Company

like

What ctc to expect if my cctc is 8.5.
Tech: Devops
YoE: 1.5
TIA

like

Additional Posts in Googlers & Xooglers

Hey hey guys.
I am looking for a good example of a cv of a mbb consultant who moved to a FAANG. Any guidance here

like

Thinking of moving out of Google, which companies do Xooglers move to in Dublin?
(L5 GBO Dublin)

like

Should all the on-site interviews have a feedback of "hire/ strong hire" in order to proceed to HC?
What if one of rounds was not up to the mark?

like

Do Nooglers receive salary increases? And if so when do you find out?

like

Non-eng... Got past the hiring committee! 🥳 does anyone know the process from now? And how long it typically takes? Thanks !

like

Can we start a thread for all the acronyms? Y’all lose me with all the lingo 😂

funnylike

Had on-site a month ago and recruiter has promised an update several times and not followed through. Anything I can do other than following up once a week? I think I’m the backup candidate but would be helpful to get more clarity

like

Google S&O manager total compensation expectations in Bay Area ? Please suggest numbers as I need to negotiate soon, thank you.

like

How high can google go on signing bonus ( currently $25k) and equity (currently $65k) for L4 position.. total exp 4 years .. should I negotiate?

like

can anyone shed some light on what kind of leadership development/training programs are available to senior leaders at Google? like public speaking for example? how do they choose who to offer these training opps to?

like

Recruiter shared post on-site feedback and she mentioned that she would like to do the team match and do 1-2 additional rounds of interviews because the feedbacks now are borderline and have a very low chance of HC. Any team here who's hiring SAP Program Manager role? Please kindly keep in contact with me :)

like

Are there any roles at Google that would consider someone coming from Private Equity Ops (with consulting background) or is that too far removed? About to take a PE position but would like to know if it hurts my chances at moving to Big Tech one day - thank you

Is there a difference between strategy & operations and business operations & strategy?

like

Any from Google Cloud looking for Customer Engineers? I passed my onsite, but currently recruiter mentioned there is not headcount to fit me in. Happy to be squeezed in anywhere at this point.

like

When will google hiring resume?

like

Generally how long are on sites? Are they all on one day’s block? The entire 4 hours?

helpful

Hi everyone, would anyone know how many years of experience as a minimum is required for the programme manager role in GCP? Doesn’t say anywhere on the job description, TIA!

like

Any insights on Cloud consultant role in GCP PSO in terms of project pipeline, growth opps , wlb , etc.

like

Currently interviewing for a nontechnical role (final round is getting scheduled rn) and I see there’s a new job posting for a different role that I might be more excited by, for the same/associated team. What do I do?? Email my recruiter saying I want to be considered? Apply? How does going for two roles work? The referral from the original job I’m interviewing for has expired fwiw.

like

I have applied to several positions up Google. I have not heard anything back at all. No matter if I customize my résumé to the job description I still don’t hear anything back. I am wondering as to why Google ghost people instead of just telling them that they didn’t get the job? Do people on Google believe it is appropriate for the recruiters just a ghost people especially if they feel they don’t match the job?

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

Scan your QR code to download
Fishbowl app on your mobile

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