A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY businesscategory_id' at line 6

SELECT businesscategory_id, businesscategory_name, COUNT(*) AS businesscategory_count FROM businesscategory, business, property WHERE businesscategory_id = business_businesscategory_id AND business_property_id = property_id AND property_street_id = GROUP BY businesscategory_id