CREATE TABLE INVOICE (CustomerId VARCHAR(255)); CREATE TABLE CUSTOMER (Address VARCHAR(255), CustomerId VARCHAR(255), country VARCHAR(255))
Find the address of all customers that live in Germany and have invoice.
    
SQL: SELECT DISTINCT T1.Address FROM CUSTOMER AS T1 JOIN INVOICE AS T2 ON T1.CustomerId = T2.CustomerId WHERE T1.country = "Germany"