I\'m using sql and I\'m confused as to whether I would just count branch number
ID: 3754446 • Letter: I
Question
I'm using sql and I'm confused as to whether I would just count branch number where position is assistant or if it is more complex than that
Mary Howe Aitant 19-Feb 70 000 eity posscode type rooms rent ownerNio stafmhNo branchNo |650 -opertyN street 16 Hohead! Aberdeen |AB7SU|House|6 Argyll StLondon Nwz Lawrence St G GI oxFlat C0465A 8007 400 CO87 SA005 5Novar Dr |Glasgow |G12 9AX |Flat |4 430 C093 G4 B00 clientNo fName Name teiNo CR John Kay 0207-774 5632 as CR4 Mike Ritchie 01475-392178 House 754o prefType maxRent eMai Aline Stewart 0141-48-1825 Flt Mary Tegrar 01224-196720 a mritchied1 eyahoo.cou marnPhotmailonuk ownerNo Name IName address eMail password COs Keogh Fergus Di,Abenderen AB2 75X 01224 81212 ghitsh.com co Carol Faret Achray St.Glasgo G32 90X 0141 357-419 cfarelgmail.com OHI T- Murph7|63well SL Glasgow G42 Cov Tomy Shaw 12 Park PL Glasgow G4 0QR 0141-225-7025 tomy shaarkcom 0541-943-1728 tiamhotmal.com dlientNio propertyNo viewDate comment clientNo branchNo staffNo dateJoined 24-May-1 too small -Age-13too remot SL41 2-lan-13 CS 003 G1-Apr-12 CR74 BOOS CRA B007 3G37 16-Nov-11 SA9 7-Mar-12 CRZ PA14 no dining roomExplanation / Answer
Select Branch.branchNo ,count(propertyNo) from Branch inner join PropertyForRent on Branch.branchNo = PropertyForRent.branchNo inner join Staff on Staff.staffNo = PropertyForRent.staffNo group by Branch.branchNo having position = 'Assistant';
Do ask if any doubt. Please upvote.