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

Нравится

Войдите чтобы поставить Нравится
Комментировать

Войдите чтобы прокомментировать
Распространить

Tweet

Тесты по
SQL

Присоединяйся и изучай SQL

или Узнай больше о Тесты по SQL онлайн

Следи за CodeGalaxy

Мобильное приложение Beta

Обратная Связь