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 recorde possui Jardas de 192 e um Touchdown menor que 1?
 ###Tabelas: CREATE TABLE names_and_fleet_details (names_and_fleet_details_id AUTO_INCREMENT PRIMARY KEY, Original number VARCHAR, UIC number VARCHAR, Name VARCHAR, Constructer VARCHAR, constructor number INT, Year INT, Withdrawn VARCHAR, Kilometers worked INT) CREATE TABLE all-time_liga_acb_table (all-time_liga_acb_table_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Season INT, Played INT, Lost INT, 1 st VARCHAR, 2 nd VARCHAR, 3 rd VARCHAR, 4 th VARCHAR, Debut VARCHAR, Since/Last App VARCHAR, Best INT) CREATE TABLE financial_results (financial_results_id AUTO_INCREMENT PRIMARY KEY, Year INT, Turnover VARCHAR, Net income VARCHAR, Balance sheet total VARCHAR, Employees INT) CREATE TABLE michigan_single-game_reception_yardage (michigan_single-game_reception_yardage_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Rec. INT, Yards INT, Average INT, s Touchdown INT, Year INT, Opponent VARCHAR) CREATE TABLE bc_augsburg_versus_tsv_schwaben_augsburg (bc_augsburg_versus_tsv_schwaben_augsburg_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, League VARCHAR, Teams VARCHAR, Home VARCHAR, Away VARCHAR)  
SELECT AVG Rec. FROM michigan_single-game_reception_yardage WHERE Yards = 192 AND s Touchdown < 1