Using SQL DML find the answer to this question:

1. List the name of the Clients and property owners in one table.

Branch branchNo street city postcode BOOS B007 B003 B004 B002 22 Deer Rd London SW1 4EH 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow G11 9QX 32 Manse Rd Bristol BS99 INZ 56 Clover Dr London NW10 6EU Staff staffNo Name Name position sex DOB salary branchNo SL21 John White Manager M 1-Oct-45 30000 BOOS SG37 Ann Beech Assistant F 10-Nov-601 2000 B003 SG14 David Ford Supervisor M 24-Mar-5818000 B003 SAS Mary Howe Assistant F 19-Feb-70 9000 SG5 Susan Brand Manager F 3-Jun-40 24000 B003 SL41 Julie Lee Assistant F 13-Jun-65 9000 B005 B007 Property For Rent propertyNo street city postcode type rooms rent ownerNo staffNo branchNo PA14 16 Holhead Aberdeen AB7 5SU House 6 650 C046 SA9 B007 PL94 6 Argyll St London NW2 Flat 4 400 C087 SL41 BOOS PG4 6 Lawrence StGlasgow G11 90X Flat 3 350 C040 B003 PG36 2 Manor Rd Glasgow G32 40X Flat 3 375 C093 SG37 B003 PG21 18 Dale Rd Glasgow G12 Houses 600 C087 SG37 B003 PG16 5 Novar Dr Glasgow G12 9AX Flat 450 C093 SG14 B003 4 Client clientNo Name IName telNo prefType maxRent eMail CR76 John Kay 0207-774-5632 Flat 425 john.kay@gmail.com CR56 Aline Stewart 0141-848-1825 Flat 350 astewart@hotmail.com CR74 Mike Ritchie 01475-392178 House 750 mritchie01@yahoo.co.uk CR62 Tregear 01224-196720 Flat 600 maryt@hotmail.co.uk Private Owner Mary ownerNo Name Name address telNo eMail password C046 Joe Keogh 2 Fergus Dr, Aberdeen AB2 7SX 01224-861212 jkeoghelhh.com CO87 Carol Farrel 6 Achray St, Glasgow G32 9DX 0141-357-7419 carrel@gmail.com C040 Tina Murphy 63 Well St, Glasgow G42 0141-943-1728 tinam@hotmail.com C093 Tony Shaw 12 Park Pl, Glasgow G4 OQR 0141-225-7025 tony shawark.com Viewing Registration clientNo propertyNo viewDate comment clientNo branch No staffNo date Joined CR56 PA14 24-May-08 too small CR76 B005 SL41 2-Jan-08 CR76 PG4 20-Apr-08 too remote CR56 B003 SG37 11-Apr-07 CR56 PG4 26-May-08 CR74 B003 SG37 16-Nov-06 CR62 PA14 14-May-08 no dining room CR62 B007 SA9 7-Mar-07 CR56 PG36 28-Apr-08