Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- SQL
- -- TASK 1
- SELECT *.tab1, *.tab2
- FROM tab1
- RIGHT JOIN tab2 ON id.tab2 = id.tab1
- -- TASK 2
- SELECT *
- FROM tab1
- UNION
- SELECT *
- FROM tab2
- -- TASK 3
- SELECT splt_tab.region, splt_tab.cost
- FROM
- (SELECT *, REGEXP_SUBSTR(campaign_name,'[^_]+',1,1) AS item
- ,REGEXP_SUBSTR(campaign_name,'[^_]+',1,2) AS format
- ,REGEXP_SUBSTR(campaign_name,'[^_]+',1,3) AS region
- FROM SOURCE) AS splt_tab
- GROUP BY splt_tab.region
- -- здесь сделана группировка в целом по регионам без разбивки на кампании
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement