Raymond_Garcia
Contributor II

SELECT count(*)

FROM (

 SELECT explode(mmycolumn)

 FROM table

 WHERE created_year = 2022 and created_month = 7 and created_day = 5

)

WHERE col.field is not null and col.field.field! = "signal"

View solution in original post