Table: primera_a_2006_teams
Columns: place_posici_n
team_equipo
played_pj
won_pg
draw_pe
lost_pp
goals_scored_gf
goals_conceded_gc
dif
points_pts

Question: What was the top place with over 24 points and more than 14 played?
SQL: SELECT MAX("place_posici_n") FROM primera_a_2006_teams WHERE "points_pts" > 24 AND "played_pj" > 14

Question: What is the sum of all points for places above 8?
SQL: SELECT SUM("points_pts") FROM primera_a_2006_teams WHERE "place_posici_n" > 8

Question: What is the average number played for place 2 and more than 4 lost?
SQL: SELECT AVG("played_pj") FROM primera_a_2006_teams WHERE "place_posici_n" = 2 AND "lost_pp" > 4

Question: What is the largest number of points for Orion with more than 4 losses?
SQL: SELECT MAX("points_pts") FROM primera_a_2006_teams WHERE "team_equipo" = 'orion' AND "lost_pp" > 4