Table: spanish_football_records
Columns: rank
club
season
goals
apps

Question: What are the apps for less than 61 goals and before rank 6?
SQL: SELECT SUM("apps") FROM spanish_football_records WHERE "rank" < 6 AND "goals" < 61

Question: What season was Barcelona ranked higher than 12, had more than 96 goals and had more than 26 apps?
SQL: SELECT "season" FROM spanish_football_records WHERE "apps" > 26 AND "club" = 'barcelona' AND "goals" > 96 AND "rank" > 12

Question: How many apps when the rank was after 13 and having more than 73 goals?
SQL: SELECT AVG("apps") FROM spanish_football_records WHERE "goals" > 73 AND "rank" > 13

Question: Who was the club having less than 22 apps and ranked less than 2?
SQL: SELECT "club" FROM spanish_football_records WHERE "apps" < 22 AND "rank" < 2