SELECT support_type.Support_Type, COUNT(*) AS qty
FROM support_type, raw_data
WHERE support_type.Support_ID=raw_data.Support_Type AND raw_data.Date BETWEEN '$start' AND '$end'
GROUP BY support_type.Support_Type
ORDER BY qty DESC
Member requests are more likely to be responded to.
Members can monitor the statuses of their requests from their account pages.
A CCM membership gives you access to additional options.