updated query for seats and amount