Table: demo_party
Columns: year
amiga_demo
pc_demo
c64_demo
amiga_intro
pc_intro

Question: Who won best amiga demo when tribes ( pulse & melon dezign) won best pc demo?
SQL: SELECT "amiga_demo" FROM demo_party WHERE "pc_demo" = 'Tribes ( Pulse & Melon Dezign)'

Question: What won best amiga demo when alto knallo (free electric band) won best pc demo?
SQL: SELECT "amiga_demo" FROM demo_party WHERE "pc_demo" = 'Alto Knallo (Free Electric Band)'

Question: What won best pc intro when my kingdom (haujobb & scoopex) won best amiga demo?
SQL: SELECT "pc_intro" FROM demo_party WHERE "amiga_demo" = 'My Kingdom (Haujobb & Scoopex)'

Question: What won est pc intro when 4k0 (polka brothers) won best amiga intro?
SQL: SELECT "pc_intro" FROM demo_party WHERE "amiga_intro" = '4k0 (Polka Brothers)'

Question: What won best pc demo when tower power (camelot) won best c64 demo?
SQL: SELECT "pc_demo" FROM demo_party WHERE "c64_demo" = 'Tower Power (Camelot)'

Question: What year did fr-08: the product ( farbrausch ) win best pc intro?
SQL: SELECT "year" FROM demo_party WHERE "pc_intro" = 'FR-08: The Product ( Farbrausch )'