EFC Country Performance about web HOT 5 CLOSED

SELECT events.ID,eventName, CAST(AVG(entries) AS Integer), CAST(AVG(eventPosition) AS Integer), CAST((100/(AVG(entries))*AVG(eventPosition)) AS Integer)
FROM events
LEFT OUTER JOIN eventData ON eventData.eventID = events.ID
LEFT OUTER JOIN results ON results.eventID = events.ID
WHERE eventType = 'EFC' AND catID = 6AND fencerClubID = 415
GROUP BY eventName
ORDER BY CAST((100/(AVG(entries))*AVG(eventPosition)) AS Integer) ASC

SELECT 
SUM(CASE WHEN eventPosition = 1 THEN 1 ELSE 0 END) AS first, 
SUM(CASE WHEN eventPosition = 2 THEN 1 ELSE 0 END) AS second, 
SUM(CASE WHEN eventPosition = 3 THEN 1 ELSE 0 END) AS third, 
SUM(CASE WHEN eventPosition > 3 AND eventPosition < 9 THEN 1 ELSE 0 END) AS last8, 
SUM(CASE WHEN eventPosition > 8 AND eventPosition < 17 THEN 1 ELSE 0 END) AS last16, 
SUM(CASE WHEN eventPosition > 16 AND eventPosition < 33 THEN 1 ELSE 0 END) AS last32, 
SUM(CASE WHEN eventPosition  > 32 AND eventPosition < 65 THEN 1 ELSE 0 END) AS last64, 
SUM(CASE WHEN eventPosition  > 64 AND eventPosition < 129 THEN 1 ELSE 0 END) AS last128, 
SUM(CASE WHEN eventPosition  > 128 AND eventPosition < 257 THEN 1 ELSE 0 END) AS last256, 
SUM(CASE WHEN eventPosition  > 256 AND eventPosition < 513 THEN 1 ELSE 0 END) AS last512
FROM results 
LEFT OUTER JOIN events ON events.ID  = results.eventID 
LEFT OUTER JOIN eventData ON eventData.eventID = results.eventID AND results.dateID = eventData.dateID where eventData.catID=6 AND results.eventCat=6 AND eventType = 'EFC' AND fencerClubID = 415