SELECT * FROM Contacts; SELECT * FROM Contacts JOIN EmailAddresses ON Contacts.contactId = EmailAddresses.contactId; SELECT * from PhoneNumbers JOIN Details on Details.detailId = PhoneNumbers.detailId; SELECT * from PhoneNumbers JOIN Details on Details.detailId = PhoneNumbers.detailId WHERE PhoneNumbers.contactId=42; SELECT * FROM Contacts JOIN Addresses ON Contacts.contactId = Addresses.contactId WHERE displayLabel like '%oduma%'; SELECT * FROM Addresses JOIN Details on Addresses.detailId=Details.detailId WHERE Addresses.contactId=7; SELECT * from Organizations where contactId = 7; SELECT * from EmailAddresses JOIN Details on Details.detailId= EmailAddresses.detailId where EmailAddresses.contactId = 8; SELECT * from PhoneNumbers JOIN Details on Details.detailId = PhoneNumbers.detailId where PhoneNumbers.contactId = 4; SELECT imageURL from Avatars where contactId = 8;