I am wondering if my query would work because it is different from the solutions and it is just a theoretical task without a Database

54 views Asked by At

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