What other options are there to write such SQL?

Question

SQL

There is a problem , I solved it like this:

select name from Company
left JOIN Trip on Trip.company = Company.id
where Trip.plane = 'Boeing'
GROUP BY name

I am confused by the fact that when joining the flights table to the companies table, it turns out that all records from the flights table for this company are pulled up to one company record (because of this, as a result, I group these records).
Although the first found flight for each company is sufficient to solve the problem, it is not necessary to search for all records in the flights.

Perhaps it can be solved somehow easier?

Answer 1

EXISTS

Answer 2

why are you grouping instead of limit 1 ?