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 partido Joseph T. Johnson estava?
 ###Tabelas: CREATE TABLE 2010_2011_table (2010_2011_table_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Played VARCHAR, Drawn VARCHAR, Lost VARCHAR, Points for VARCHAR, Points against VARCHAR, Tries for VARCHAR, Tries against VARCHAR, Try bonus VARCHAR, Losing bonus VARCHAR, Points VARCHAR) CREATE TABLE record_vs._other_most-played_di_opponents (record_vs._other_most-played_di_opponents_id AUTO_INCREMENT PRIMARY KEY, Kansas State vs. VARCHAR, Games played INT, Overall Record VARCHAR, Last 5 Meetings VARCHAR, Last 10 Meetings VARCHAR, Current Streak VARCHAR, Last Meeting VARCHAR) CREATE TABLE remixes (remixes_id AUTO_INCREMENT PRIMARY KEY, Year INT, Artist VARCHAR, Song VARCHAR, Album VARCHAR, Remix VARCHAR) CREATE TABLE south_carolina (south_carolina_id AUTO_INCREMENT PRIMARY KEY, District VARCHAR, Incumbent VARCHAR, Party VARCHAR, First elected VARCHAR, Result VARCHAR) CREATE TABLE season_3_1998–99 (season_3_1998–99_id AUTO_INCREMENT PRIMARY KEY, Series # INT, Season # INT, Title VARCHAR, Directed by VARCHAR, Written by VARCHAR, Original air date VARCHAR)  
SELECT Party FROM south_carolina WHERE Incumbent = joseph t. johnson