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.
SQL
SQL Quiz
Start Quiz

or Read more about SQL Quiz

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback