I've got the following task: Find each company hat is located in every city in which 'FBC' is located. Follwoing entities:

employee(ID, person_name, street, city)
works(ID, company_name, salary)
company(company_name, city)
manages(ID, manager_id)

I wrote the following query:

select company_name
from company
where city in
(select city
from company
where company_name = 'FBC')

They used a nested query with not exists and exept but I found that too complicated. What do you mean? Thanks and best regards!

0

There are 0 answers