Rating
Hyatt Hotel Canberra
Commonwealth Avenue Yarralumla ACT 2600
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=3941 or tblfeedback.strbusinessname='Hyatt Hotel Canberra' or tblfeedback.strbusinessname='Hyatt Hotel Canberra') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating
Rating
Rydges Capital Hill
Canberra Ave (cnr National Cct Forrest ACT 2603
SELECT count(intrating) AS reviewsCount, round(avg(cast(intrating AS float)),2) AS rating FROM tblfeedback INNER JOIN tblmember on tblmember.lngMemberID=tblfeedback.lngmemberID WHERE (lngsupplierID=19191 or tblfeedback.strbusinessname='Rydges Capital Hill' or tblfeedback.strbusinessname='Rydges Capital Hill') and year(getdate())-year(dtmadded)<=15
star ratingstar ratingstar ratingstar ratingstar rating