Table: bradford_city_records
Columns: name
goals
apps
avge
career

Question: What is the highest number of apps of the player with more than 63 goals and an avge of 0.45?
SQL: SELECT MAX("apps") FROM bradford_city_records WHERE "goals" > 63 AND "avge" = 0.45

Question: What is the total avge of John Hall, who has less than 63 goals?
SQL: SELECT COUNT("avge") FROM bradford_city_records WHERE "name" = 'john hall' AND "goals" < 63