I was given a SQL take home prompt which is actually getting tough. It’s asking me to have different column names for current and previous IDs and having to show the output for the last 4 engineer hires for each of 4 companies (16 hires) with their past job info. How does one select this in SQL? Do you use CASE WHEN or UNION or something else? Getting stumped and can’t find relevant info online. For analytics position. Any recommendations?

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

ChatGPT

like

There’s a couple of ways you could go about this. Hard to give advice without knowing how the data is structured tough.

My fist instinct would be to utilize CTE’s to break the data out to the necessary components and then combine them with a single select at the end. Though I’ll be the first to admit that my SQL-fu could be sharper.

Look up cross joins

like

Use “as” for renaming the columns if this is an issue

If you’re not joining on a column, just combine the tables. Select a, b, c (or *) from x, y, z (cross join). But sounds like you need the employees to match so you need to find another column to match on that’s different from the employee ids (maybe name). That’s even simpler just a regular outer join.

It may be tough to accept but keep in mind if it’s beyond your level the job might not be for you. You don’t want to be struggling every day and not able to ask for help because you cheated on the test.

Related Posts

like

I have an interview at a company tomorrow with Head of Software Engineering of a company , what questions can I expect , how can I prepare for those qns , my work experience is not that great if he/she asks me work related qns , please assist its for SDE role.

Is anyone have opening related to HR fielfield

like

Hiring for many roles in LTI.

Please comment if you are interested.

Valid till end of Aug
but sooner the better

Skills:
Matillion
AWS Architect
Azure Architect
Bigdata Architect
Informatica Architect
IBM MDM
AWS with Redshift API
Azure DataBricks Developer

Let me know.

like

What types of rounds can i expect from Google, for AI/ML role in Google cloud team? I have a phone screening round scheduled for tomorrow. Thanks

like

Does anyone know how much Wells Fargo pays for Lead Software developer position in Charlotte area? I have 12+ years exp

like

Hi I am holding an offer from both Bdo rise and wellsfargo and the package is same 14 LPA. I am bit confused as the role eat bdo rise offering is quite good but not sure about the culture and other wlb in bdo rise Can anyone suggest which one will be good wellsfargo or bdo rise..

Are there any ea roles hiring (mainly Chi but flex to elsewhere) with chill creatively minded environments? I am great at the work but can’t deal with the typical buttoned up seniority bootlicking LOL

like
like

Hello Everyone

I have 16+ YOE in B2B Sales and Fintech, SME, Loans, Corporate Sales based out of Bangalore. Currently working for Fintech company as Regional Business Head from last 4 and half years and I am looking for change.
Request everyone refer job openings.

like

Anyone have experience working in sales for a startup? What are things to consider? Got a recruiter contacting me about an open position very similar to what I do now, at a startup.

Dear Friends, I am looking for an IT Project Manager job. Let me know if you have any opening for this role. Work experience: I have 13years of experience in the IT industry.

Key Skills: Project Management, Customers and stakeholders management, worked on Cloud migration project, worked on new customer transition, Transitioning project to BAU,IT operations

Technical Skills : AWS, Azure, VMware, Windows Server 2012/2016/2019

like

How do you navigate when you've already accepted an offer, but you get a better one? I'm supposed to start a new role tomorrow but got an offer for the job I really wanted, and it pays 50k more. Is it horrible if I quit while having just started?

like

How is the interview level of Software Engineer at Capgemini? What are the questions that can be expected from java domain for same position?

like

Hi I wanted to know more about the big wins team at IQVIA, and the skill set they are looking for.
Also I have close to 11 yrs of experience all in pharma consulting and forecasting what position I cam expect and what compensation package.

Hi All - Is IQVIA hiring for SFE roles? If yes, Can someone help me with a referral?

like

Hi all,
I’ve 10+ years experience in accounting/data analysis/management reporting based in NYC. I’m good at wearing different hats, advanced Excel, efficient and organized. I’m also known to be a thorough and patient teacher. I’m looking to transition into a role doing more FP&A with good WLB. Any referrals offered greatly appreciated!

like

Curious about the biz dev career track. Have you stayed in biz dev your whole career? Or did you start in biz dev and use it to move into another role? What did you move into and how?

like

Hello, I have 5 years of experience in manual testing, I have been referred in Infosys for the role of Technical Test lead. Can you guys tell me what kind of questions will they ask and how can I get prepared for that?? Thanks in advance!!

like

Opening for Senior QA at Oracle.
Location: Bangalore, Trivandrum
Dm for referral

like

More Posts

What’s the furthest you’d drive for fertility treatments? I had to do clomid iui with my daughter and trying for number 2 but the office isn’t accepting new patients at this time

like

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

like

Does nike provide employee coupon discount to its employees ?? Nike
I want to exchange some adidas coupons there’s some sick snickers i want to buy but want some discount coupons

funny

Thoughts on Nokia's upcoming 2/4 earnings call? Got a call expiring 2/5 😬😬😬

I currently work as a senior accountant in Nashville. Is it possible to go to public accounting?

likefunny

Boston Consulting Group BCG interview coming up. What are compelling reasons for answering reason looking to move when coming from competitor?

like

Am super close to DMs, let’s make it happen 🫡

like

𝐔𝐊 & 𝐄𝐮𝐫𝐨𝐩𝐞: Few Recent Notable SuccessFactors EC & ECP Country Specifics!

#SAP #SuccessFactors #HXM #Europe #UK

Post Photo

Does anyone have any advice for aging parents and making decisions on where to put them for assisted living? Are there trusted and unbiased sites that offer info on quality and safety ratings etc?

like

What international city would you want to live and work in and why?

like

How does one go about getting a client side job?

like
like

A partner just walked from his office. By passed 4 or 5 people who are generally more knowledgeable on our banking logistics straight to the only black support staff employee to@ask if today is a bank holiday.

likefunny

What are the top Supply Chain Mgmt schools for good ROI (in 2-3 years post graduation)? I have seen Harvard and MIT in so many lists but you’re paying through your nose for these too.

like

My bank makes you fill out a form if you want to work in the office for each individual day. It’s largely empty from what I hear. What are the risks if I were to go in and “borrow” an office chair for my new apt? How about a monitor?

funnylike

does anyone else feel pressured to go to grad school if they want to become a data scientist after analytics consulting?

likesmart

Hello all,

Would like to know specifically about Queer inclusion at SocGen
Societe Generale. What is the attitude of mangers and HRs towards treating LGBTQ identifying candidates? Is company really inclusive or it’s just a lip service? Considering an offer with the company but being an out and proud Queer woman, super anxious and concerned.

Hi all,
Looking for a career change, I’ve experience in project management, oncology, health promotion, engagement, inclusion and diversity and hoping to work for a pharma. Happy to relocate and would love some guidance and referral please 🙏🏾

like

Do you think diversity training actually works? I can't tell if it's just a way to tick a liability box or if it's actually effective.

like

Additional Posts in Tech

Are there any panels of female industry leaders that are worth checking out?

likeuplifting

Data analyst trying to break into data science. Anyone willing to network?

like

Did anyone know about ccna and CompTIA exams certificates?

like

Anyone who is an SDET? How much coding do you do?

like

What are some things you guys wish you knew before you started your NetSuite implementation?

I’m at a small company that’s sort of becoming medium sized, and a new exec pushing to quickly implement NetSuite and I just want to make sure we’re not getting in over our heads, he’s trying to get this done within two months

We currently use Salesforce, quick books, and excel, we’ll be consolidating a lot of accounting and finance stuff into netsuite and integrating it with Salesforce

like

Should I stay at a company I know I like culture-wise when my manager said they will try to promote me, but with no guarantee. Or should I take a job offer I was given with a nice raise, but is in consulting at Slalom. I have not worked in consulting before. There is no travel with Slalom, but the idea of being the new person all the time isn’t too appealing. Less pay and known culture, or more pay unknown job satisfaction?

like

Any CLT,NC businesses looking to hire for a Junior level Full stack developer / Junior Front-End Developer/ Technology Associate /Systems Engineer entry level / IT Support Engineer??

like

If you were only 5 months into working a tier 3 company and then got an offer from a tier 1 company, how much higher would the TC need to be for you to potentially burn that bridge?

like

Have you ever accidentally insulted your boss, pretty hard core, in a meeting? What I do? It was a total foot in mouth, but it was a huge meeting. I feel like if I avoid an apology it might actually be better for me so that we can pretend I didn't realize it was insulting and was just harmlessly talking...

likehelpful

I’m a cyber security professional with a security clearance looking to get into cloud security. I’m trying to figure out if I should go for AWS or Microsoft Azure. Which would be the best route to take? Which route is more beneficial?

like

Hi, Is there anyone in here who is a QA (Quality Assurance or Tester)? Can someone share how to get started in QA If you have no tech background? I would love to get some insights if you are someone who has transitioned into QA or testing with no prior experience or background, and how did you get your roles ?

Thanks a lot!

like

What kind of laptop does Apple provide to employees? Does it have to be Mac?

likesmartfunny

What’s the salary/Comp range for a Microsoft technical specialist in a HCOL city?

like

My marketing people - does anyone else's company have a dedicated "Marketing Response Team" (MRT Team)? Or something similar? Might be called something else at other companies and I just have no clue.

Hi. Looking for referrals at Salesforce. Happy to jump into a call to discuss my candidacy. Thank you! 🙏🏽

like

Anyone work at Robinhood that can offer insight into what it’s like there?

like

What’s the minimum total comp I should get if asked to move to SF or NY from a LCOL city? I have 2 yoe

like

So working on an aging monolith system and trying to put a whitepaper together to explain the reasoning for transition to a headless setup.

Starting with absolute basic of separation of concerns and git branching projects and cloud / blob hosting for imagery on a cdn.

These are the quick wins I think.

Just looking for some insight if anyone has any experience on something like this. The backend is java IBM I series and the front end makes me want to cry.

like

So, I just fired my first employee as a manager and I'm heartbroken. He was a great, great person but after 6 months on a PIP he just wasn't cutting it skills-wise. I know he was the provider of the household and his wife didn't have a job since she was raising three young ones. Needless to say, I had to take off because I felt terrible, sick to my stomach. How do you deal with firing guilt? Is that a thing? I can't help but feeling like I did something wrong.

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