Removing duplicates values with join
Use the next query

SELECT
B.Company,
COUNT(DISTINCT A.Ticket) AS QTY
FROM Table1 A
INNER JOIN Table2 B
ON A.CompanySk = B.EDWCompanySK
WHERE A.StartedDate &gt;= '20171128'
GROUP BY B.Company
ORDER BY QTY DESC