SQL - Multiple Counts that are grouped, from multiple tables, with a join thrown in. : Hoping for some help on this topic. I've found related things but nothing that encompassed my whole problem. 

I have two tables that hold image paths. The counts of approved images should equal the count of published images but I have evidence that they do not. One table has to have a join to group by the same criteria as the other table. I only want to return rows where the two counts don't match up. I've included the two queries I have that would return the data individually. Even if I tried to use Excel as a crutch, the amount of rows this query would return is in the millions. 

Query 1
select product_id, count(*)
from published p
join published_set ps on ps.id = p.media_set_id
group by ps.product_id

Query 2
select product_id, count(*)
from media
where status in 'APPROVED'
group by pro_sku

I did use Excel to pull one category of products that I suspected was the worst and got 8,000 mismatches out of 12,000 products. I want to compare this to other areas of the website, which I believe have little to no mismatches. My suspicion is a system is inserting data into the table incorrectly in a specific category. 