SELECT COUNT(tr.ticketnum) AS 'Product tickets by Rep', tp.prodcode, tr.repid, (COUNT(tp2.compprodtick)/COUNT(tp.prodcode)) AS 'Percent'
FROM TicketRep AS tr
JOIN TicketProduct AS tp
 ON tr.ticketnum = tp.ticketnum
JOIN
(SELECT prodcode, COUNT(prodcode) AS 'compprodtick'
FROM TicketProduct
GROUP BY prodcode) AS tp2
ON tp.prodcode = tp2.prodcode
 GROUP BY tp.prodcode, tr.repid;