python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - case-statement

CASE STATEMENT + COUNT function not working - SQL Big Query

when i run this code it does not seem to be working in big query... SELECT date, COUNT(CASE WHEN product = "fan" AND product color = "white" THEN product_co...
test-img

Laura Choi

sql

count

google-bigquery

case-statement

Votes: 0

Answers: 0

Way to prevent case statement from excluding values?

i'm pretty new to the sql world and i've seem to run into a roadblock. Multiple conditions seems to be a regular question but I couldn't find a thread on my current problem. I'm using google data stud...
test-img

J Jo

google-data-studio

multiple-conditions

case-statement

Votes: 0

Answers: 1

Latest Answer

Count them in separate columns for each category: credit: case when contains_text(answer, 'credit bureau') then 1 else 0 end a mini: case when contains_text(answer, 'mini') then 1 else 0 end), profani...
test-img

Bohemian

Posts

Questions

Blogs

Jobs