Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # имя таблицы выбрано самостоятельно т.к не указано в задании
- SELECT partner, snap_date, COUNT(DISTINCT msisdn) as MAU
- FROM table
- WHERE typename = ‘subscribe’ OR typename = ‘prolong’;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement