Table: liga_mx_clubs
Columns: club
first_season_in_top_division
number_of_seasons_in_top_division
first_season_of_current_spell_in_top_division
number_of_seasons_in_liga_mx
top_division_titles

Question: What is the highest Number of seasons in Liga MX for Club cruz azul?
SQL: SELECT MAX("number_of_seasons_in_liga_mx") FROM liga_mx_clubs WHERE "club" = 'cruz azul'

Question: What is the highest Number of seasons in Liga MX for Club cruz azul, when their season in the top division is higher than 68?
SQL: SELECT MAX("number_of_seasons_in_liga_mx") FROM liga_mx_clubs WHERE "club" = 'cruz azul' AND "number_of_seasons_in_top_division" > 68

Question: What is the total number of Top division titles for the club that has more than 40 seasons in top division, a First season of current spell in top division of 1943-44, and more than 89 seasons in Liga MX?
SQL: SELECT COUNT("top_division_titles") FROM liga_mx_clubs WHERE "number_of_seasons_in_top_division" > 40 AND "first_season_of_current_spell_in_top_division" = '1943-44' AND "number_of_seasons_in_liga_mx" > 89

Question: How many top division titles does Club Guadalajara have, with more than 42 seasons in Liga MX?
SQL: SELECT SUM("top_division_titles") FROM liga_mx_clubs WHERE "number_of_seasons_in_liga_mx" > 42 AND "club" = 'guadalajara'

Question: Which club has fewer than 40 seasons in Liga MX and 65 seasons in the top division?
SQL: SELECT "club" FROM liga_mx_clubs WHERE "number_of_seasons_in_liga_mx" < 40 AND "number_of_seasons_in_top_division" = 65