Table: election_results_1986_2
Columns: district
incumbent
party
first_elected
result
candidates

Question:  how many district with incumbent being lindy boggs
SQL: SELECT COUNT("district") FROM election_results_1986_2 WHERE "incumbent" = 'Lindy Boggs'

Question: what's the result with candidates being billy tauzin (d) unopposed
SQL: SELECT "result" FROM election_results_1986_2 WHERE "candidates" = 'Billy Tauzin (D) Unopposed'

Question:  how many candidates with result being retired to run for u. s. senate republican hold
SQL: SELECT COUNT("candidates") FROM election_results_1986_2 WHERE "result" = 'Retired to run for U. S. Senate Republican hold'

Question: what's the result with district being louisiana 2
SQL: SELECT "result" FROM election_results_1986_2 WHERE "district" = 'Louisiana 2'

Question: who is the the candidates with first elected being 1977
SQL: SELECT "candidates" FROM election_results_1986_2 WHERE "first_elected" = 1977