This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: agency? select phoneNumber from AgencyTbl where name='Bayleys' Creating SQL Queries 3. For each offer worth more than 30000, list the amount and the name of the agency that negotiated the offer. Jia Yi Lu 2009S2 10 select amount, agencyName from OfferTbl where amount > 30000 Creating SQL Queries 4. For each offer, list the name of the client who made the offer, the address of the house for which the offer was made. Jia Yi Lu 2009S2 11 select ClientTbl.name, OfferTbl.amount, HouseTbl.address from ClientTbl, OfferTbl, HouseTbl where ClientTbl.id = OfferTbl.clientId and HouseTbl.id = OfferTbl.houseId Exercises See tutorial 3 exercise sheet. Jia Yi Lu 2009S2 12 3 To do • Module 6 software exercises • Assignment (due 07/09/2009) • Practice tests (online) Jia Yi Lu 2009S2 13 Next tutorial is in Week 8 (After the study break) Please bring your text book with you!...
View Full Document
This note was uploaded on 06/01/2010 for the course PN 115.107 taught by Professor Ivan during the Spring '10 term at Massey Palmerston North.
- Spring '10