Table: cycling_grand_tour_positions
Columns: rider
year
final_position_giro
final_position_tour
final_position_vuelta

Question: What is the average year that has a final Tour position of 54 and a final Vuelta position over 55?
SQL: SELECT AVG("year") FROM cycling_grand_tour_positions WHERE "final_position_tour" = 54 AND "final_position_vuelta" > 55

Question: What is the final Vuelta position associated with a final Giro position over 39 and a final Tour position of 90?
SQL: SELECT "final_position_vuelta" FROM cycling_grand_tour_positions WHERE "final_position_giro" > 39 AND "final_position_tour" = 90

Question: How many Giro positions are associated with the year 1971 and Tour final positions over 50?
SQL: SELECT COUNT("final_position_giro") FROM cycling_grand_tour_positions WHERE "year" = 1971 AND "final_position_tour" > 50