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: Qual é a classificação, quando o evento é Johnson Vs. Dodson?
 ###Tabelas: CREATE TABLE comparison_of_toy_group_breeds_of_major_kennel_clubs (comparison_of_toy_group_breeds_of_major_kennel_clubs_id AUTO_INCREMENT PRIMARY KEY, The Kennel Club (UK) Toy Group VARCHAR, Canadian Kennel Club Toy Dogs Group VARCHAR, American Kennel Club Toy Group VARCHAR, Australian National Kennel Council Toy Dogs Group VARCHAR, New Zealand Kennel Club Toy Group VARCHAR) CREATE TABLE fox_partnership (fox_partnership_id AUTO_INCREMENT PRIMARY KEY, Event VARCHAR, Date VARCHAR, Rating VARCHAR, Share VARCHAR, Viewers VARCHAR) CREATE TABLE title_holders_from_1973_until_1991 (title_holders_from_1973_until_1991_id AUTO_INCREMENT PRIMARY KEY, Year INT, Binibining Pilipinas-Universe VARCHAR, Binibining Pilipinas-International VARCHAR, Miss Maja Pilipinas VARCHAR, Binibining Pilipinas-Tourism VARCHAR, First runner-up VARCHAR, Second runner-up VARCHAR) CREATE TABLE models_and_engines (models_and_engines_id AUTO_INCREMENT PRIMARY KEY, model VARCHAR, max. motive power VARCHAR, max. torque at rpm VARCHAR, engine displacement VARCHAR, engine type VARCHAR, engine configuration & notes 0-100km/h VARCHAR) CREATE TABLE men's_singles (men's_singles_id AUTO_INCREMENT PRIMARY KEY, Seed INT, Rank INT, Player VARCHAR, Points INT, Points defending INT, Points won INT, New points INT, Status VARCHAR)  
SELECT Rating FROM fox_partnership WHERE Event = johnson vs. dodson