Untitled

MCFoger

Jun 6th, 2025

450

179 days

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

PostgreSQL 0.84 KB | None | 0 0

raw download clone embed print report

SELECT COUNT(*) FROM breed_ads;
SELECT SUM(clicks)
FROM breed_ads
WHERE country_group = 'Tier1';
SELECT
100.0 * SUM(CAST(clicks AS FLOAT)) / NULLIF(SUM(CAST(impressions AS FLOAT)), 0) AS ctr_percent
FROM
breed_ads
WHERE
breed = 'breed_1';
SELECT breed, COUNT(*) AS freq
FROM breed_ads
GROUP BY breed
ORDER BY freq DESC
LIMIT 2;
WITH ctrs AS (
SELECT
breed,
audience,
SUM(CAST(clicks AS FLOAT)) / NULLIF(SUM(CAST(impressions AS FLOAT)), 0) AS ctr
FROM
breed_ads
WHERE
audience IN ('Female', 'Male')
GROUP BY
breed, audience
)
SELECT
f.breed,
f.ctr AS female_ctr,
m.ctr AS male_ctr,
f.ctr - m.ctr AS ctr_diff
FROM
ctrs f
JOIN ctrs m ON f.breed = m.breed AND f.audience = 'Female' AND m.audience = 'Male'
WHERE
f.ctr > m.ctr
ORDER BY
ctr_diff DESC;

Add Comment

Please, Sign In to add comment