Given two tables:
Employees:
ID  Name CompanyID
1    John   100
2    Bob    100
3    Leon   200
....................
....................
Companies:
CompanyID      CompanyName      CompanyAge
   100        MetroManufacture     10
   200        NaturalEquipment     20
   300        MemoryIndustrial     25
Select a query that will return list of names of those people who do not work in companies with CompanyAge greater than 15 years.

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback
Cosmo
Sign Up Now
or Subscribe for future quizzes