gteCdbmQ

1select 
2U.session_id,
3U.session_date,
4U.email
5from data.usage U
6left outer join
7  select 
8  distinct M.session_id
9  from data.usage M
10  where email like '%gmail.com%'
11  and data_date >= '20180101'
12  and name in
13    ( 
14    select 
15    lower(name)
16    from data.users
17    where role like 'Person%' 
18    and isactive = TRUE
19    and data_date = '20180412'
20    )
21on U.session_id = M.session_id