help with excluding a value from output

Select count(distinct campaign_id) as TotalCampaigns from `public_sponsored_instagram_posts` WHERE brand_id is not '7230' 

I’m not sure why i’m getting an error with the query above. I essentially would like to count the # of distinct campaign_ids except for one, which has the brand_id 7230.

submitted by /u/trufflegrilledcheese
[link] [comments]


Go to Source of this post
Author Of this post: /u/trufflegrilledcheese
Title Of post: help with excluding a value from output
Author Link: {authorlink}