Salesforce interview question

DB joins. Types? Sample query for few?