sql query error

Question

With the following query:

SELECT SeatPref FROM (SELECT SeatPref, COUNT(CustID) AS seat_count FROM Booking 
    GROUP BY SeatPref) WHERE seat_count = max(seat_count)

I am getting the following error:

Every derived table must have its own alias.

Answer 1

You Should add an alias to the subquery (SELECT SeatPref, COUNT(CustID) AS seat_count FROM Booking GROUP BY SeatPref).

:)

Answer 2

You are missing table alias -

SELECT t1.SeatPref 
FROM (SELECT SeatPref, COUNT(CustID) AS seat_count 
      FROM `Booking` 
      GROUP BY SeatPref)  t1
WHERE t1.seat_count = max(t1.seat_count)