Can anyone help with this sql problem

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

Schema is missing but should be a simple Union query.

like

Union of two queries. Each query needs to be formed with either Left Join or Not In clause.

Hackerrank interview Test ka question lag raha hai.

like

Related Posts

28 F making 132k. I don’t do much in retirement planning yet but hope to start maxing out this year. Should I do traditional or Roth?

like

Bought a 12 years old condo. First time home owner. Can someone share what all things would need more care(electrical appliances, vents, filters etc) to avoid costly maintenance.

like

Anyone get share options in a startup included in an offer? Thoughts? Advice?

like

What are the hours typically in expected EY Parthenon transaction and execution practice? Is there a lot of weekend work?

like

Tips for Belize!!

1. Safety Concerns
2. Accommodations (Airbnb/Hotel is better)
3. Is it worth to get a car?
4. Activities to do?
5. Neighboring cities to visit?

Group of 5 in their mid 20’s, and we’re planning to visit early/mid February for about 8-9 days. We’re already doing research but additional advice from experienced travelers is always welcomed.

like

looking for friends in nyc to hang with and yes i am desperate enough to post on fishbowl for it. my isolation level is over 9000 and i just moved here 😂😅🥲😩😭 it’s cold out there without the homies to keep you warm 🥶

likefunny

Hi need advice on below!

Offer from Accenture 7LPA for level 11.2.

5.5 years of experience on accounting and finance R2R operation.

Is this right ?? Rightly paid

like

Feeling de-motivated as a consultant in healthcare. Doesn’t feel like a lot of the work I do actually helps patients or make anyone’s life better, which was the whole draw when I started 5+ years ago. I also sometimes feel stifled bc healthcare doesn’t have the $ and growth opps that I see my peers that work in other industries. Anyone ever feel this way?

like

What’s Centene’s reputation to the outside world? You can be honest. I understand the overall distain for health insurance companies in general. I’ve been experiencing a lot of internal conflict after surviving 2 acquisitions in 4 years, most recently by Centene. All it took was 1 Google search to make me start questioning everything.

like

Looking for referrals for DevOps role,
Stack azure cloud, docker, ansible, k8s, jenkins, microservices

Yoe 3.4

like

It’s dark outside so damn early. So is anyone in this town doing any work that’ll brighten up the creative scene in this city?

like

Anyone know the process behind getting access to pre market trading with a Schwab account? Is special access needed to be requested? And is there an extra cost per trade/share?

like

In a recruiter perspective, how is the background check process done when there’s a third party company involved? I’m assuming information is provided and recruiters reach out to previous employers correct?

like

What are signs that an offer is coming?

Feeling down after getting a rejection for my top choice law school 😕😭

like

Is refermarket legit? I see many people getting that message on referrals and wanted to make sure it was a real and useful thing.

hi fishes,
I have joined lti as a lateral.
After joining they have asked me to collect laptop from office. When i went, the laptop was not in a great condition and was refurbished. I am guessing it was used almost 3 to 4 years before me.

I asked them for a new laptop and they said they dont have new laptop in stock, i even checked with my manager she said she is also using refurbished laptop so no problem.

Anyone else faced this problem earlier?. If yes how did you act on it?

How do you get over the fear of failing? Do you think failing is part of the process?

like

Do PE firms hire tech experts to help with Tech DD or they mainly rely on consultants? I’m quite interested in going “in house”. I am part of Bain’s IT practice and work at intersection of CDD and TDD.

like

Has anyone used Noom? Feedback?

like

Additional Posts in Offer Negotiations

Hi Fishes,
Why companies are looking for immediate joiner(15~30days) but they are giving 90 days NP to offer letter.
Any comments what to do in this situation?

like

For SDET role :

1. Wynk Airtel Gurgaon
2. Ivanti Bangalore
3. Qburst Bangalore

Which one would be a better choice to join ? My lwd is 2nd and really need to make a decision now.

I have left 10 days of notice period. I am waiting for an offer so I can counter to the one offer i am holding.
What is the minimum days a company needed to update the offer after sending the counter offer.
I am aware that the existing company has the budget to match my expectation.

like

I have a 5 years of experience in Power BI and have good knowledge in SQL. What should be my salary according to the market standards?

like

Is it fine if i change jobs frequently ? I have 10 yoe this is my third company . I joined 3 months ago Now I am planning to change .

like

IT Infrastructure Project Manager with total of 8+ years experience and package is quite low. What are the market standards ? Please advice folks.

like

DM me or reply in the comments, if anyone's looking for a referral in KPMG.

like

I am working as a senior QA in a service based firm. My current package is 25L with 9 YOE . I was getting 13L before and year. My friends say, I am underpaid. Can somebody please let me know, how much salary I can target for ?

like

Hi friend
Help me choose
Yoe - 9.5
Tech Mahindra
Mind tree
Capgemini
LTI
Please provide your feed back on hikes and wlb and growth

like

is 18lpa less for BA4 dev in Barclays? YOE - 6.7. Full stack - React, Java, Oracle. Seeing posts with 22L+ for 4 YOE itself. bit confused

like

What is senior analyst position at ey? How many years would be required for promotion from this role

like

Boa vs pwc? Kya join krna chahiye?

like

Hi Fishes, As the recession is coming. I am really worried that I switch or not. I have got an offer from HERE Technologies . Can anyone please suggest what should I do? I have 1.7 YOE in Android/Java application development with some devops experience as well. The last working for TCS is mostly in the last week of December. I am new in the IT industry but have worked on upwork as a freelancer during my college.

like
like

I have 3 days to accept the TCS offer and i also have 1 offer from CTS ( with almost 2.5 lakh more). The problem is it doesn't make sense to join just for 40k more because of expensive city life. Is there any way to negotiate with TCS or CTS HRs for wfh and maybe with a lesser package. Please Suggest.
I want to switch because my current job is a contractor job
yoe : 4.5
tech : java spring boot
tcs : 12.1
cts: 14.5

like

Hi Fishes,

I'm currently working in
Infosys Ltd My

Skills: Java, Spring boot, Angular (Html, CSS, Typescript), Sql: Oracle DB, MySQL, Python

YOE - 2 Years

I got offer from TCS for Java Developer for the CTC 9LPA with Joining bonus of 50K

Can I join TCS or I can still remain in Infosys for better salary package

Please suggest, I'm confused

like

Hi guys, I got offer from Mindtree(23) GlobalLogic(26+1) and To The New(TTN) (28).
Any suggestions? Which one to join. GlobalLogic Mindtree TO THE NEW

like

Could someone please tell me the take home & what are the deductions that mostly happen ?

Post Photo
like

I have two offers , company A offers better pay than company B (20% including joining bonus). But I like company B ? Work culture and type of work is similar? Company B has little better benefits also. Please help how to decide?

like

I pay ever year around 5.5 lakhs in taxes. ( I save tax through maximum possible HRA, section 80 C, section 80E. Can any CA help in reducing total tax further. Willing to share a fee based on savings. Please DM

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