VladikOtez

2

Dec 28th, 2016
155
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT id,
  2.        FROM flights AS f
  3.         WHERE distance < (
  4.             SELECT AVG(distance)
  5.           FROM flights
  6.             WHERE carrier=f.carrier);
RAW Paste Data