Trying to complete this requirement
*Show the 10 Restaurants with the highest number of violations,
Only display this information for restaurants with 5 of more inspections on record.
Display the following information for each restaurant:
– the restaurant name,
– the number of inspections for the restaurant,
– the total number of violations for the restaurant, and
HINT: Not all inspections result in violations
–START OF CODE
SELECT TOP (10) COUNT((Inspection ID)) AS Expr1, (DBA Name), (Inspection Type), Results, Violations FROM FoodInspectionOriginal, Organization, InspectionViolations, Inspection WHERE (InspectionID) IN (SELECT InspectionID From Inspection WHERE InspectionID > 5 )(SELECT InspectionID FROM InspectionViolations WHERE ViolationCode is not null); GROUP BY (DBA Name);
–END OF CODE
and I am getting this error
Msg 156, Level 15, State 1, Line 47
Incorrect syntax near the keyword ‘GROUP’.