Tables in my database: 1. Employee
2.Aircraft
3.Certified
Query: I need to find pilot name, eid, aircraft name, cruising_range where pilot is certified to fly more than 3 aircraft's . i wrote a query and it works but i want to know if there is a simple way to achieve this because my query seems much complicated .
My query is :
Edit: Corrected the name of tables.