What are questions one can expect for a SQL interview? Position is for Sales Strategy and ops associate at Linkedin

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

Had a SQL interview for an industry position. The questions can be as simple as the difference between a left join and an inner join to harder ones like what’s primary key or giving you a scenario/request and asking you to write SQL statement. Hope this helps.

like

Related Posts

like

We’re hiring across the board at KPMG for cyber / cyber risk work - shoot me a DM if interested. (Pays well!)

likehelpful

Hello Fishes,
What salary should I expect from Deloitte India for SAP MDG tech. I am having total 2 year of experience. They are offering me consultant role.
Please provide answers in figure if possible.
Looking forward for your responses.
Thanks in advance!

like

Hi All,

I am going to attend interview for Cloud Support Engineer 1 (Network & Security). Can anyone help me with the salary I can ask for this role. I have 3.5 years of experience.

like

I’m hiring for a director of patient accounts! PM me for details!

like

Anyone have any insights on the banking & financial services practice at Cognizant in Canada?

like

Is the amazon application status of active vs archived (not in consideration) accurate?

like

TCS Hr revised my ctc to 27.5lpa from 24lpa for C3A band & shared ctc break up. I negotiated asking him to revise the fixed comp to 26lpa & JB. He said that he would try for fixed comp of 26lpa but no JB. Later he came back saying he can't get an approval for 28lpa & asking me if I'm okay with 24lpa & he would try to get 24lpa also if possible. Is he trying to get the ctc down or does he can't get approval? How do I get him to give the 27.5lpa break up offer? YOE:9y6m Role:Infra ManagerTata Cons

Post Photo
like

Can someone put light on work culture and work life balance in aws bangalore team. Specially aws migrations teams. Got an offer and planning to join there. However worried about wlb based on the feedback over internet

like

Hello Fishes,

I have been working as a Management Consultant from Aug-21.
But the job role isn't what was told to me earlier. Hence looking to switch.
Any Help and Guidance is highly appreciated.

Total Exp- 6+ years
Exp: FMCG (Logistics and Supply Chain), Consulting (Team Lead)
CTC- 18 Lacs
Expected CTC- 25+ Lacs

Thanks In Advance.

like

How to sell yourself in an FP&A role interview? I only have audit experience

like

Hi Fishes,
Which one to choose from the below two?

Tiger Analytics - Data Engineer
LatentView Analytics - Data Engineer

PS: Salary not deciding factor!!

like
like

Hello All,
Small help please. What is expected salary range for principal consultant (BA role) ?
How much can I expect on top of 25L fix pay? Also what principal consultant role is equivalent of in general terms ?

like

I’m an analyst & have been working towards associate – I was recently offered an associate role on a different team, but simultaneously am feeling burned out and thinking of leaving the firm within the next 6-8 months to work at a smaller company. I want to accept the associate role for my own professional development and growth. Tips on leaving a role after 6 months without burning bridges? Is that possible? I feel somewhat guilty about leaving my team, but know I have to prioritize my career

like

Hie folks ,
I applied in Bosch India through there website, the application says in progress since two weeks should I assume I will not hear from them . Or should I reach out to them . Does it takes this much time to get a reply

like

Hey everyone,

Anyone has referrals to any startups that are hiring any of the following roles:
Generalist
Operations
HR
Recruiting
Business management

I’m looking to be involved with a pre-seed, seed, series A or series B startup that provide remote work, good benefits and a decent salary.

like

Spotify has a couple of really interesting remote first-positions open. What’s their salary range at Director level in EU?

like
like

More Posts

Any mid to senior level US Corp finance folks want to head to a tier 1 US firm in London? Hours around 2100 - top cola, could do double sign on for the right person.

Please DM.

like

I am so glad women are speaking up about harassment. Like Matt Lauer...

like

I have an appointment to get lip fillers for the first time. I want natural looking results, nothing too big. I know it takes time to settle, but will I be able to go to work the next day without it being noticeable?

like

I had IVF process to get pregnant. During pre- embryo transfer we were told that girl embryo is being transferred. Currently I am 18 week pregnant. I had anatomy scan and we found out we are having a boy. Baby looked all healthy but due to gender discrepancy, We are asked to do additional testing and genetic disorder screening. Anyone had similar experience?

McKinsey & Company I am joining the McKinsey & Company Boston office in late July and searching for housing in the meantime. If I could get some insight on the ratio of days in the office vs work from home that would be super helpful!

If I need to come into the office regularly I will try to find a place close by.

like

Is it worth making the time/money investment to make the switch from big 4 FDD to MBB. This would require getting into and paying for a top MBA program and my net worth would be way negative after that. Are the MBB financial returns worth it? Im 26 years old for reference

like

When does RSM find out about promos/bonuses/etc?

like

Tell day 8th Nov!

like

Hi all, Interviewing for a principal customer solutions manager role at Amazon. Can anyone share details on what kind of questions to expect for the first round? Second round? Thanks!

like

Recommendations on buying work shoes for guys? Any new designs? Favorite company? Need to buy two new pairs.

like

Had a panic attack at work and had to leave bc I felt like I was going to puke at my desk... I feel like a disappointment to my team, since I couldn’t go to the client site. First bad day in a while):

like

What’s the dress code for zoom interviews? So far, I’ve definitely been dressed more formally than my interviewers but could be because they were tech companies

like

What are your tips on convincing a fellow employee not to switch agencies? I really don't want to compete with them

like
like

If I leave my consulting role and move to a recruiting role at Accenture for a year to build skills, will it be hard to go back into a tech role? I have experience in Change Mangement and Project Management, but I temporarily want a change. Eventually I want to move to a role at FAANG

like

Lunch at the Denver Centurion Lounge. So excited to get back on the road! Eventually... Who else is just returning to work travel and how has it been?

Note: this was actually taken on a personal trip in late May. I was just connecting through Denver.

Post Photo
likeuplifting

Trump for past several weeks: Mail in voting is fraud. Fraud fraud fraud. Massive bigly fraud.

Trump aides: Sir you are losing in Florida, a key battleground state.

Trump today: Mail in voting is perfectly safe and secure and I recommend it, in Florida.

likefunny

Additional Posts in Consulting Exit Opportunities

Is google still hiring? I see some transitions from D to Google but wonder whether I should apply or sit tight?

like

Any insight into the Product Development Specialist role at Facebook? My goal is product management and I am currently a strategy consultant with 3 YOE (not technical), but this seems like a possible path toward that goal. The initial total comp brought up was only $110K (base, bonus, stock), which is barely more than I am making now, though they said there was room to negotiate on the stock portion.

likefunny

Hey Fish Fam, I am about to put in my two weeks notice at a Big4. Going to industry. Any sage advice or pointers on what to say and what not to say/do? I really enjoyed working at B4 and made amazing network of supportive colleagues however this opportunity is way too good to pass. Any help is appreciated, thanks!

like

Anyone have experience with Qventus? Recruiter reached out and I’ve never heard of them. Looking for insights on comp, WLB, etc.

like

How do you answer the salary expectations questions? Got out on the spot and just tacked on 10% more than my current but apparently that was more than the recruiter expected

like

Can someone explain the difference between FB’s Partner Solutions Manager and the Strategic Partner Manager? From an initial recruiter call, it seems the SPM provides the consultative product recs while the PSM onboards the client onto that product and tracks performance to provide actionable recs as needed. Anyone know career growth and salary for these two? I don’t want a sales heavy/only lateral growth role like their client solutions manager roles so these seem like good compromises?

like

What do you think the offer breakdown is for Sr Product Manager role at Intuit? $300k Total Comp feasible? Heading into final round, want to be prepared in case they put out an offer. Seeing a lot of variety on Glassdoor/Levels.fyi/etc. 9 YOE, M7 MBA, Consulting Manager with 3 yrs of Product exp.

like

Is it a good idea to message the recruiter posting the job on LinkedIn before applying? If so, what should I write?

Or should I just apply?

like

Asking for a friend - any thoughts or prior experience on joining a new team at AWS selling a brand new cloud product? What will the wlb of a small team be? Does a small team with limited business equal to poor wlb and grind culture?

Anyone make an exit as a SDE or other type of Engineer to Amazon? What’s the work life balance like? Interview process?

like

What are the consequences of being 'caught' faking a competitive offer to negotiate a higher TC at companies like Google? Not sure how one would get caught (pretend offer is non-FAANG). Am I missing something here?

like

Would you rather take an offer at BCG as a consultant or at Walmart as a Product Manager? Currently at a top 10 MBA program.

likehelpfulfunny

Currently at Deloitte and considering leaving. Is it worth jumping from one Big4 to another? Seems like getting into Industry is not working out.

like

How difficult is it to go from bizops at FAANG to MBB without prior consulting experience?

like

Is it awkward to tag your previous managers to thank them in a LinkedIn new job announcement post for a new company? Awkward for the managers?

like

What’s the draw of product marketing? I see a lot of my MBA classmates going into these roles but don’t really get the appeal

like

Looking for full stack developer to join my early startup. We are a small team but hoping to grow a lot this year. Must love books and geeky stuff

like

I want to exit to MBB but if that’s not a possibility what are the next best consulting firms? Looking for at least midsize firms (non-boutiques).

like

Seems like consulting is becoming less and less of an attractive field to be in, and people are leaving the industry in droves. Is this because of the pandemic? What gives?

like

When people refer to e-commerce exits they are typically referring to platforms like amazon. If I’m more interested in working for an e-commerce store/seller rather than a platform is there a better term for this so I can research better?

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