Table: election_results_2002
Columns: district
incumbent
party
first_elected
result
candidates

Question: What party was Kevin Brady?
SQL: SELECT "party" FROM election_results_2002 WHERE "incumbent" = 'Kevin Brady'

Question: What district has Ron Paul?
SQL: SELECT "district" FROM election_results_2002 WHERE "incumbent" = 'Ron Paul'