Skip to content

Instantly share code, notes, and snippets.

@JidLaurence

JidLaurence/gist:319aed253b92cc9b47c8e1e3f9aa52c8

Created January 1, 2024 01:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JidLaurence/319aed253b92cc9b47c8e1e3f9aa52c8 to your computer and use it in GitHub Desktop.
Save JidLaurence/319aed253b92cc9b47c8e1e3f9aa52c8 to your computer and use it in GitHub Desktop.
Download ZIP
Test 3
Raw
gistfile1.txt
SELECT
c.CampaignName,
COUNT(DISTINCT r.RoundID) AS RoundsCount,
COUNT(s.SegmentID) AS SegmentsCount
FROM
Campaigns c
LEFT JOIN
Rounds r ON c.CampaignID = r.CampaignID
LEFT JOIN
Segments s ON r.RoundID = s.RoundID
WHERE
c.CampaignName LIKE 'MyTestCampaign%'
GROUP BY
c.CampaignID, c.CampaignName
HAVING
COUNT(DISTINCT r.RoundID) >= 3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment