Table: drogheda_united_f_c
Columns: season
competition
round
club
1st_leg
2nd_leg
aggregate

Question: What is the club when 1st leg is 1–2?
SQL: SELECT "club" FROM drogheda_united_f_c WHERE "1st_leg" = '1–2'

Question: What is the competition when aggregate is 1–4?
SQL: SELECT "competition" FROM drogheda_united_f_c WHERE "aggregate" = '1–4'

Question: What is the 1st leg when club is a.c. libertas?
SQL: SELECT "1st_leg" FROM drogheda_united_f_c WHERE "club" = 'A.C. Libertas'

Question: What is the 1st leg when 2nd leg is 1–0 and competition is uefa champions league?
SQL: SELECT "1st_leg" FROM drogheda_united_f_c WHERE "2nd_leg" = '1–0' AND "competition" = 'UEFA Champions League'

Question: What is the competition when 2nd leg is 0–8?
SQL: SELECT "competition" FROM drogheda_united_f_c WHERE "2nd_leg" = '0–8'

Question: What is the round when 1st leg is 0–1?
SQL: SELECT "round" FROM drogheda_united_f_c WHERE "1st_leg" = '0–1'