Select nl_id, count(distinct user_id) as sent_num from sheet1$ Where event_type='nlsent' group by nl_id
, nl_opencount AS (
SELECT nl_id, count(distinct user_id) as open_num from Sheet1$ where event_type = 'nlpv' group by nl_id
select a.nl_id, sent_num, open_num, ROUND(open_num/sent_num, 2) * 100
from (nl_sentcount a
inner join nl_opencount b
on a.nl_id = b.nl_id)
The result look like this.
Why will the last column be 0? How should I fix it to get none 0 value?