SQL quiz. Given two tables: <pre><code class="sql">Employees

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.


select Name from Employees where Employees.CompanyID not in (select CompanyID from Companies where CompanyAge > 15)


select Name from Employees where Employees.CompanyID not between (select CompanyID from Companies where CompanyAge > 15)


select Name from Employees, Companies where Companies.CompanyAge > 15

Explanation

Sub-query and NOT IN operator should be used for that.

in-operator

Like

Login in to like
Comment

Login in to comment
Share

Tweet

SQL
Quiz

or Read more about SQL Quizzes

Follow CodeGalaxy

Mobile Beta

Send Feedback