3. Write a query to list the client numbers and total numbers of properties that match the client preferred type.

112 Chapter 4 The Relational Model Figure 4-3 Instance of the Dream Home rental database SWI GEH Branch branchNo street city postcode B005 22 Deer Rd London B007 16 Argyll St Aberdeen AB23SU B003 163 Main St Glasgow GT 90X 1004 32 Manse Rd Bristol R999 INZ B002 56 Clover Dr London NWIO SEU Staff staffNo Name Name position Sex DOB salary branchNo SL.21 SG37 SG14 SA9 S55 SL41 John White Manager M Ann Beech Assistant F David Ford Supervisor M Mary Howe Assistant F Susan Brand Manager F Julie Lee Assistant F 1-Oct-45 30000 BOOS 10-Nov-60 12000 B003 24-Mar-5818000 B003 19-Feb-70 9000 B007 3-Jun-40 24000 B003 13-Jun-65 9000 BOOS Property For Rent property No Street city postcode type rooms rent ownerNo staffNo branchNo PA14 16 Holhead Aberdeen ABZSSU House 6 650 0046 SA9 B007 PL94 6 Argyll St London NW2 Flat 4 400 C087 SL41 B005 PG 6 Lawrence St Glasgow G11 90X Flat 3 350 C040 B003 PGM6 2 Manor Rd Glasgow G32 40X Flat 3 375 C093 SG37 B003 PG21 18 Dale Rd Glasgow G12 Houses 600 CO87 SG37 B003 PG16 5 Novar D: Glasgow G12 9AX Flat 4 450 C093 SG14 B003 Client clientNo Name IName telo prefType maxRent Mail CR76 CR56 CR74 CR62 John Aline Mike Mary Kay 0207-774-5632 Flat Stewart 0141-848-1825 Flat Ritchie 01475-392178 House Tregear 01224-196720 Flat 425 350 750 600 john.kay@gmail.com astewart@hotmail.com mritchie01@yahoo.co.uk maryt@hotmail.co.uk Private Owner password ownerNo Name IName address telNo eMail C046 Toe Keogh 2 Fergus De Aberdeen AB2 75X 01224-861212 krogh@lhh.com C087 Carol Farrel 6 Achray St. Glasgow G32 9DX 0141-357-7419 carrele gmail.com . C040 Tina Murphy 63 Well St. Glasgow G42 0141-943-1728 tinam@hotmail.com C093 Tomy Shaw 12 Park Pl. Glasgow G4OQR 0141-225-7025 tony shawark.com Viewing Registration cllentNo property No viewDate comment clientNo branchNo staffNo dateJoined CR56 PA14 24-May-13 too small CR76 PG4 CR76 20-Apr-13 to remote SL41 CR56 PG4 CR56 26-May-13 B003 SG37 CR62 PA14 CR74 B003 SG37 CR56 PG36 28-Apr-13 B007 SAS 7-Mar-12 B005 14-May-13 no dining room 2-Jan-13 11-Apr-12 16-Nov-11 CR62