Here’s a list of the top 20 SQL interview questions that are commonly asked, along with brief explanations:

### Basic SQL Questions:
1. **What is SQL?**
- Structured Query Language, used for managing and manipulating relational databases.

2. **What are the different types of SQL commands?**
- **DDL (Data Definition Language):** `CREATE`, `ALTER`, `DROP`
- **DML (Data Manipulation Language):** `SELECT`, `INSERT`, `UPDATE`, `DELETE`
- **DCL (Data Control Language):** `GRANT`, `REVOKE

Hey Fishes can someone help with Product Owner interview pattern at Cerner

Have a week to prep. Anyone wanna case in prep for strategy firms? Was interviewing for MBB so pretty well versed just need a refresher

Hi Everyone,
Currently I am looking to make a career change into the real estate industry, specifically commercial real estate. However, LinkedIn messages have failed to successfully get me an interview to talk with someone from this field. Does anyone have experience/insight on how I could better make connections with people in this field?

Any recommendations on where to go to brush up on your Boolean search techniques? I’ve been recruiting for 10 years, but admit I don’t know the latest ways... for example X-ray

what was the most impressive question a candidate has asked during an interview?

For those who didn’t make the switch from IB, how much time did it take to prep to a point where you felt ready to interview for PE associate roles?

Hello All,

I had finished my managerial round on friday. Can anyone let me know when will i get to know if I am selected or not. How much time does amazon takes to declare the result?

Hi all! I got rejected from JPMorgan for their Global Finance and Business Management program (through my resume, couldn’t make it to interview). However, I’d reached out to recruiters and am meeting with one in a couple of days! Do I have a shot at turning this around? Or will it not matter once she learns I was rejected. Thanks!

Any thoughts on interviewing with 1.5-2 YOE in consulting, what level I would be coming in as at BCG? Wasn’t informed in my interview offer

What's the review process for firms. I have people getting rejected but I haven't heard anything. Is it interviews, offers, rejections? Or is it review/ interview and rejections then offers.

Question for yall. How likely is an offer once a company decides to do a reference check? I know I am in the final 2, from context clues in interviews. I just dont want to get my hopes up.

Hi folks, any idea about the current hiring process for an experienced hire at big4? I meant in terms of total duration.

Anyone from Nationwide? I’d like to hear feedback from current and old employees about the work environment, salary (G3), development, diversity etc. I completed an interview for Claims Manager position.

Is anyone here a client service associate ? I have just been offered a position as one. It didn’t seem like a call center in my interview but now that I’m speaking with people it does seem like one. Can anyone provide any insight? I need my series 7 and 63.

I am getting third party company mails ,like working for xx client should I apply them?

Interviewing at Microsoft and they are doing a centralized interview in 1 day. Essentially I will have 4 straight hours of interview with a 15 minute presentation. Does this sound normal for Microsoft? Any suggestions for interviewing there?

Hi All! What does that mean when hiring manager responds back on follow-up email, saying “I’ll keep you posted on the next steps”Are they still considering or is it just a new way of rejection?waiting is so painful. :(

I have 2 case interview with BCG in North America PL role. Any advice on cases? How many should I practice? What sort of cases do they give? Is it candidate or interviewer led?

Cleared technical round of MPHASIS, what should I expect in client round(BlackRock)

What’s something people assume about your role in this industry but isn’t true?

Going to Italy end of October, planning on visiting the Lamborghini and Ferrari museums. Which Ferrari museum is better? Modena or Maranello? Or is it worth it to visit both?

Hello Fishes, please refer me if any Cards BA opportunity in your organisation. TIA.

A colleague i work with just went through a third miscarriage, I would like to get her a gift. Something that shows I care. Any advice on what would be most helpful? I was thinking a good book. Any other place ideas / record? Would really appreciate.
Thank you 🙏🏼

I have a background in ops consulting, would it be possible to break into Corp dev?

Will I burn bridges if I don't do a full two weeks notice?

For example if I put in my 2 weeks on a Wednesday, will I burn bridges if my last day is the following Friday?

I personally think that's more than enough time especially since it's 7 business days (instead of 10), but would love to hear thoughts

A friend is interviewing for a role managing one of the pieces of software McKinsey uses/sells to clients and has a case coming up. Anyone know good resources for him to use to brush up?

What is the MBB admissions rate for HSW, approximately?

If you are already in biotech R&D, been in hardcore engineering/ research is it worthwhile to pivot to data science?

Creatives that use PowerPoint disgust me that is all have a good day.

401k Roth or traditional 401k?

Journalism is the best job in the world but I feel like people are less likely to take my work seriously because I am female. So it's like they automatically think the only things I would be good at writing about are fluffy little human interest stories. I'm just a reporter like everyone else. Is there some way I can tell my supervisor that yes, I do like those stories, but I like being a serious reporter even more?

How many meetings a week do you find necessary when there aren't any special launches and/or campaigns?

Any US based Big 4 employees ever do a secondment to your offshore team’s country (e.g. India or Philippines) or is that not common? If so, care to share your experience??

Happy back door Roth Day, if you celebrate.

Best late night car service in town (that isn’t lyft or uber)?

How much weight do you put into your gut feeling of "I do not like my interviewer who would manager me" if you think it could just be you have unrealistic expectations

Fish, need some help. Who do you recommend for a tailor for suits in DC area?

Is Integration Engineer position at Zoom worth joining coming from Software Engineer position?

Hi , am working as branch service manager in home appliances company and I completed 11yrs in this company and total experience is 13yrs. Now am looking to change. Pl suggest

I have completed 8 months in the current org and my Notice Period is 90 Days.
If I resign and serve notice , my tenure at current workplace will be 11 months.
Should I work for one more month and resign ?
Or should I resign right away and serve 2 months notice period and buy out one months notice ?

Please guide.!!

Hi fishes,
I'm a data analyst with 3 year working experience. Could anyone give me referal for Myntra, flipkart, Hotstar, Meesho, uber, zomato, swiggy?

I am an immediate joiner with 6 years of experience into Dot net angular fullstack development looking for a change. Please refer for same. Thanking you guys.

Hello Fishes,
Looking for a job change in DevOps role, please help with referrals.
Experience:5 years
Skillset: Linux, Docker, K8s, Python/Shell, Jenkins/GitLab CI, release management.
Notice period: 1 month

Hi Everyone,

I having below offers in hand. Please guide me for a wise decision in selecting a company

L&T - 10.5 LPA
INTELLECT DESIGN ARENA - 8 LPA
EMPOWER RETIREMENT- 10 LPA
FUJITSU- 11.5 LPA
TEKIZMA - 7 LPA

CTC is not a matter. I need good learning, WLB and good culture.

fishes,

Im software engineer with 4.2 YOE In testing,
I need some help and suggestions regarding AWS cloud testing,
If one is working in Aws cloud testing. Please ping me Itll be very helpful for me to growth pls...

Hi Fishes,

Please help me with open hearts for DM services.

Hi fishes,

Looking for an opportunity for Lead Business Analyst, Manager role at Kolkata location for Banking , Lending domain
Exp- 8

I'm an Accountant having 6+ YOE in India. Now looking for jobs in EU. Any advice about finding a job in EU