Need help with a Query.

Would someone be kind enough to help me with a query to give a report of percentages of violated SLA's vs met SLA's. I need it grouped by technician and by group please. We are running MySQL still.