title: How to write this complex SQL query?
body: <p><a href="https://i.stack.imgur.com/Wexz8.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Wexz8.jpg" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/eq6eA.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eq6eA.jpg" alt="enter image description here"></a></p>
  
  <p>I need to find the names of aircraft such that <strong>all pilots</strong> certified to operate them earn more than 60000.</p>
  
  <p>Query I wrote:</p>
  
  <pre><code>select aname 
  from employee join certified
  on employee.eid=certified.eid
  join aircraft
  on certified.aid=aircraft.aid
  where salary&gt;60000;
  </code></pre>
  
  <p>But it returns aname if there is any pilot with more than 60000 salary,difficult part is that i need to find if all pilots earn more than 60000 only then the aname is displayed.</p>