I have another table called "Leads" with the generated campaign ID associated to each record with less than a thousand record

SELECT 

"Campaign"."Campaign ID", 

        "Campaign"."Campaign Name", 

        COUNT("Leads"."campaignID")

FROM "Leads"

LEFT JOIN "Campaign" ON "Leads"."campaignID" = "Campaign"."Campaign ID"

GROUP BY

"Campaign Insights (Facebook Ads)"."Campaign ID", 

        "Campaign Insights (Facebook Ads)"."Campaign Name"

I have tried many different configurations but it either doesn't work OR it shows values WAY higher than it should...

For example

Here is the result of that query. it does what its expected, except that it is counting the amount of times the ID shows in BOTH tables rather than just counting how many times it shows on the SECOND "leads" table

Just for refference, the values in the third column should be as follows:

This was made just using the "Leads" table