Adobe Interview Question | SQL Interview Question no 20 | Daily SQL Practice | Advanced SQL

[@user-gq6cg3ls7f]

with cte as(
select * from tags cross apply string_split(tag, '#')
)
select id, value as tag, count(*) cnt from cte
where value 0
group by id, value
order by id