I have a sql coding test in a week for an interview and I’m not the most well versed in complex queries/brainteasers. If I get truly stuck multiple times, what is the best approach? The interviewer will be watching me over video. Should I admit I’m stuck, and if so, can I do that without blowing my chances?

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

Say “I’d like to walk you through my thought process, can you let me know if I’m approaching the problem the right way?”

Go through the parts of the query that are written. Then what you want the end result to look like (point A to point B). If you know what kind of transformation or calculation you need to do, great. But after that you can say you are having trouble with the exact syntax. Shows you’ve thought about it and know what the answer should look like even if you don’t have the exact answer

likesmart

Have an experienced SQL coder feed you the answers.

This is sure to end well.

likefunny

What’s the company? Might help answer based on culture (also I want to know who is gonna ask me to take a test if I put proficient in SQL on my resume lol).

SQL isn’t technical, it will be a basic requirement very soon. Just remember it was built for people who DON’T code and was meant to mimic basic language. SELECT thethingsiwant FROM wheretheyare. You’ll be fine.

Related Posts

Hi fishes,
What questions shall I expect during the VP round for Genpact??
Please help.

Does anyone currently work for a company that’s hiring? If so, would anyone like to throw a referral my way? 😇

JD - graduated in May. I started working for a small firm in March, during my last semester. I stayed with the firm until this month: pay was garbage, and supervisor started treating me poorly when they found out I was interviewing for other firms.

I’ve been applying and interviewing for months. I hate to say that I am desperate, but any advise would be desperately appreciated ☺️

like

Hi Sharks,

I have completed all my pre-joining formalities & submitted all relevant documents. Once submitting the BGV got an auto mailer saying that it would take 14 days to complete the BGV. And the days are over now. Also, so far, I didn't receive any mails.

Do I need to wait or follow up with recruiter? Please advise?

Hello Fishes,
I got an opportunity from NTT Data BPO.
I am currently being hired for nightshift. Are there any chances for getting day shift or mid shift?
Or are there any chances to get a change in shift after getting on boarded?
Will it be okay to discuss this with HR?
Because during interview I said yes to Night Shifts.

What is a realistic salary to negotiate for when applying for a VP position in Risk? Currently have 5 years of experience

like

Hi Fishes,

I have applied to one of the roles about 10 days back and I didn't recieve any calls regarding my screening or interview.

Can someone tell me how many days does it take for the initial screening to happen after applying.

Also, how much time will it take for all the process to happen ( screening + interview + final discussion).

Thanks in advance

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

Hi, after each interview, the recruiting agency will call me to get feedback and ask me if we're still good on X salary?

What's a good way to not agree on a set number on these calls until I get my offer?

like

Hi All- I’d love to hear from the community what the focus areas are for Tier 2 firms in the region Are there certain sectors the various firms specialize/ focus on? It seems like everyone focuses on public sector and tmt. Currently interviewing at a few and would be great to get some feedback. Thanks!

like

Just completed an interview for strategy manager role (internal strategy). Any comp range insights from those that jumped to an industry internal strategy role?

like

Is reaching out on Linkedin the best way to contact a recruiter, or should I look for their professional email?

like

Hi

It's important - I got data analyst offer in Designboxed. But i am in doubt because.
1.Interviewer didn't ask any technical questions. I had only one interview.
2. Evening itself I got call that i was selected and ready to discuss salary.
3. Last year it was under IT raid because of pro particular political party


Anyone know about this?

like

Hi - I am a career pivot from higher education into tech and have final round interviews for a DEI Coordinator role (which I'm super excited for). I am meeting with three people that I would be partnering with for the job and it was shared with me that these interviews will mainly be behavioral as well as questions on my technical skills. Does anyone have any resources to help me prepare for this? Anything is greatly appreciated!

like

Hi Fishes,

I have been invited for an interview for a Senior Associate position at PWC AC's ethics and compliance department. I am currently a Senior(TL) at EY, will this position of a senior associate be a sort of demotion for my career?

like

Can anyone throw some light on recruiting procedure for Nielseniq?? How many rounds and time taken to release offer letter.

like

What is the difference between Principal Design Strategist & Design Strategist?

My current title is the latter and I’m interviewing for a Principal role. The title suggests it’s more senior and would appear to be a promotion on my resume but the jd sounds similar to what I’m already doing. I’m currently and IC, Principal is also IC. The only nuance I got from the recruiter is that there is no actual designing in this role.

Is this a case of title inflation?

like

I have total 4 years of experience in IT,relevant experience in testing is 3 years,but my designation is technical support engineer,is this will create any problem during interview and during verification?please advice

like

Creative recruiters. When looking at candidates, how much does the resume matter vs. the portfolio? Do you even look at the resume? Thanks

like

Any consulting fish preparing for a PE exit willing to chat about prep and what to expect from the interview process?

like

Any good recs on resources / practice interview questions / learning materials on Alternatives?

like

More Posts

Which firm has the best reputation in DC?

like

Curious to know has anyone stumbled upon a bar(cocktails, drinks) that has also nailed social accounts so good so that besides their bar offerings people also cant wait to consume their content?

like

I currently work as a optician, referral coordinator and optometry technician. Busting my butt off wearing all 3 hats and I get paid $20 an hour… I don’t think this is a fare wage considering I’m doing the job of 3 people. I want to negotiate a higher wage any tips of what I should ask for?

like

Took REG twice and got 69 both times without studying business law. Best believe I am going to study business law to the death of me

For all the 🐠 that switched from consulting to product, which role provided you with more tangible skills? I know I’m making some broad strokes here, but thought it might open other discussions as well

like

At what point are you too specialized to lateral to internal audit? (PA, consulting, or industry roles) Currently have 2 years of external audit experience and 2 years of forensics: I always thought of internal audit as a decent exit but I’m beginning to get worried about getting too specialized to make that move one day

like

I am from Data Analytics background (YOE : 6 yrs). What's the best way to learn about Cloud Computing?
Should I go into the architecture part of it first or just directly learn about Data Engineering in AWS/Azure?
Need ur guidance!!

like

Does anyone have any tips on how to crossover to governmental affairs? I love government work, but I would like to try it from a different perspective.

like

Somehow the weekends are the worst part about GSB invites. It’s like it hits you that another week went by without anything 😔

like

New job exhaustion? I started a new consulting job on Monday and I’m mentally and physically exhausted- not from work but from the newness. Any tips? I’m embarrassed about this and surprised im not more motivated to impress

like

What is a realistic salary to negotiate for when applying for a VP position in Risk? Currently have 5 years of experience

like

Whats your TC and YOE in Canada? I'm at 130k with 8 YOE

like

I need your advice. I got an offer to join Morgan Stanley in Canada and want to know what my salary range is there. I have 10 years of experience in investment banking and will be a 5 member family living there. Can i get 200k per year, please advise. Appreciate your help on this.

Do our managers have access to our Slack conversations?

like

Hi Fam!
Any suggestions on what medical insurance we can buy for parents traveling to the US? I’m looking for reasonably priced ones that offer good coverage! My mum would need a better plan than my dad, since she recently underwent surgery! Also, is insurance better from US or Indian companies? Any tips would be greatly appreciated!

like
like

My last working day is may 31st and the salary day is also same...Will I get my salary or it will be in final settlement

like

Before taking resignation they were saying will get letter in 2 days max, now Delay in offer letter even after more than month from the day I took my resignation back.

Any suggestions will be much appreciated.

like

Is it bad form to reach out to people on here for the company I’m targeting? I’m referring to the employees who have their networking turned on so you can see their name and position.

like

Additional Posts in Consulting Exit Opportunities

Do any fish have the inside scoop on Wilson Perumal? Very little out there about this boutique...

like

What’s the longest you’ve had to wait on an offer in this climate?

like

What is the difference between corporate strategy and business development?

like

Anyone at Capital One willing to provide a referral?

like

How do the Consulting levels (1YOE > analyst, 2YOE > consultant) measure to industry levels (associate, manager, director)?

like

Any difference in roles with the title analysis vs analytics? (Ex. Business Analysis vs Business Analytics)

like

Can anyone suggest UK exit opportunities either in the Midlands (or London with significant remote), without too hefty a pay cut for an EM-level MBB with 7 total YOE? Just need some hints for places to start applying, no industry preference

likefunny

For corporate strategy roles how long is the typically end to end process (application to offer)?

like

Has anyone successfully landed a job in Europe as an American Citizen? I’m really looking into moving to London/Amsterdam or Berlin.

like

How is Advisor Business Analyst at DXC? What designation in D will that compare to?

what kind of roles at FAANG have you all exited to from management consulting?

like

Anyone here from Google specifically Google Cloud. Need to discuss about life and culture. Additionally if you are willing to refer me for a role that I see and am interested in.

funnylike

Is “BizOps” an overly glorified exit opp?

I hear about it so much on this bowl and did some googling, pretty much can’t find anything negative. What am I missing?

like

Total compensation / compensation break down estimate for PE megafund ops role w/ 3+ years of experience? Sounds like base they’re looking at is ~$120k, not sure on bonus. I’ll be over that by a bit with my promotion this year. Not sure if I’m getting lowballed, does anybody know industry standard?

like

What are some of the best questions you’ve asked/been asked during an interview?

like

Is it bad form to reach out to people on here for the company I’m targeting? I’m referring to the employees who have their networking turned on so you can see their name and position.

like

Is there a way to tell what levels are at AWS? I was contacted about a Senior Practice Manager role? B4 equivalent?

like

Can anyone comment on WLB for associate director / director roles in pharma?

like

Graduated May 2019, can I apply for campus hire jobs 🙂

like

Have an interview with a growth stage startup, what should I wear for a virtual interview ?

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