Advertisement
a_khuzina

Untitled

Nov 6th, 2024
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select p.test_group,
  2.        s.region,
  3.        count(distinct p.user_id) cnt
  4. from purchases_test_part p
  5. left join sessions_test_part s on p.user_id = s.user_id
  6. where p.test_name = 'language_test'
  7. and s.region = 'MENA'
  8. group by 1, 2
  9. order by 1, 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement