Database: bakery_1
Question: Find all receipts in which either apple flavor pie was bought or customer id 12 shopped.
SQL:
SELECT T1.receipt FROM items AS T1 JOIN goods AS T2 ON T1.item  =  T2.id WHERE T2.flavor  =  "Apple" AND T2.food  =  "Pie" UNION SELECT ReceiptNumber FROM receipts WHERE CustomerId  =  12