Related Posts
Hi All,
I just got a call from KLA Company's HR that I have cleared final round and there is a HR round today evening for salary discussions.
The role is for Frontend Developer(Angular).
I have 3.1 years of experience.
CCTC - 13.2 LPA (all fixed)
Holding offer of 17.5 from service company in Pune.
Does anybody have any reviews for this company for the s/w department?
How much should I ask?
What are the other ways I can negotiate? Like do they provide RSUs?
KLA Corporation
Thank you
Is anyone have opening related to HR fielfield
More Posts
Am super close to DMs, let’s make it happen 🫡
How does one go about getting a client side job?
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.
Additional Posts in Tech
New to Fishbowl?
unlock all discussions on Fishbowl.





ChatGPT
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
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.