Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Quantos valores de Outro A correspondem à Categoria de Tommy Johnson: Artigos com hCards?
 ###Tabelas: CREATE TABLE group_b_relegation (group_b_relegation_id AUTO_INCREMENT PRIMARY KEY, Position INT, Club VARCHAR, Played INT, Points VARCHAR, Wins INT, Draws INT, Losses INT, Goals for INT, Goals against INT, Goal Difference INT) CREATE TABLE 1969_as_three_leagues_come_together (1969_as_three_leagues_come_together_id AUTO_INCREMENT PRIMARY KEY, Portland DFL VARCHAR, Wins INT, Byes INT, Losses INT, Draws INT, Against INT) CREATE TABLE 2007_ladder (2007_ladder_id AUTO_INCREMENT PRIMARY KEY, South West DFL VARCHAR, Wins INT, Byes INT, Losses INT, Draws INT, Against INT) CREATE TABLE 20th-_and_21st-century_swiss_confederation_issues (20th-_and_21st-century_swiss_confederation_issues_id AUTO_INCREMENT PRIMARY KEY, Location VARCHAR, Date INT, Denomination VARCHAR, Coinage metal VARCHAR, Mintage INT, KM number VARCHAR) CREATE TABLE overall_scorers (overall_scorers_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Years VARCHAR, League INT, FA Cup INT, League Cup INT, Europe INT, Other a INT, Total VARCHAR)  
SELECT COUNT Other a FROM overall_scorers WHERE Name = Tommy Johnson Category:Articles with hCards