Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CONCAT(CASE
- WHEN MONTH(T1521584048.`report_date`) = 1
- AND WEEKOFYEAR(T1521584048.`report_date`) > 50 THEN
- YEAR(DATE_ADD(T1521584048.`report_date`, INTERVAL -1 year))
- WHEN MONTH(T1521584048.`report_date`) = 12
- AND WEEKOFYEAR(T1521584048.`report_date`) = 1 THEN
- YEAR(DATE_ADD(T1521584048.`report_date`, INTERVAL 1 year))
- ELSE YEAR(T1521584048.`report_date`)
- end, '-', CASE
- WHEN WEEKOFYEAR(T1521584048.`report_date`) < 10 THEN
- CONCAT(
- '0',
- WEEKOFYEAR(
- T1521584048.`report_date`))
- ELSE WEEKOFYEAR(T1521584048.`report_date`)
- end) AS t1521584048dim1weekregion,
- COUNT(T1521584048.`order_number`) AS t1521584048measure1,
- SUM(T1521584048.`order_number`) AS t1521584048measure2
- FROM `quickbi_test`.`company_sales_record` T1521584048
- WHERE (( ( CONCAT(CASE
- WHEN MONTH(T1521584048.`report_date`) = 1
- AND WEEKOFYEAR(T1521584048.`report_date`) > 50 THEN
- YEAR(DATE_ADD(T1521584048.`report_date`, INTERVAL -1 year))
- WHEN MONTH(T1521584048.`report_date`) = 12
- AND WEEKOFYEAR(T1521584048.`report_date`) = 1 THEN
- YEAR(DATE_ADD(T1521584048.`report_date`, INTERVAL 1 year))
- ELSE YEAR(T1521584048.`report_date`)
- end, '-', CASE
- WHEN WEEKOFYEAR(T1521584048.`report_date`) < 10
- THEN
- CONCAT
- (
- '0',
- WEEKOFYEAR(
- T1521584048.`report_date`))
- ELSE WEEKOFYEAR(T1521584048.`report_date`)
- end) >= '2015-03'
- AND CONCAT(CASE
- WHEN MONTH(T1521584048.`report_date`) = 1
- AND WEEKOFYEAR(T1521584048.`report_date`) > 50
- THEN
- YEAR(DATE_ADD(T1521584048.`report_date`,
- INTERVAL -1 year))
- WHEN MONTH(T1521584048.`report_date`) = 12
- AND WEEKOFYEAR(T1521584048.`report_date`) = 1 THEN
- YEAR(DATE_ADD(T1521584048.`report_date`,
- INTERVAL 1 year))
- ELSE YEAR(T1521584048.`report_date`)
- end, '-', CASE
- WHEN WEEKOFYEAR(T1521584048.`report_date`) <
- 10 THEN
- CONCAT(
- '0',
- WEEKOFYEAR(
- T1521584048.`report_date`))
- ELSE WEEKOFYEAR(T1521584048.`report_date`)
- end) <= '2015-41' )
- OR ( CONCAT(CASE
- WHEN MONTH(T1521584048.`report_date`) = 1
- AND WEEKOFYEAR(T1521584048.`report_date`) > 50
- THEN
- YEAR(DATE_ADD(T1521584048.`report_date`,
- INTERVAL -1 year))
- WHEN MONTH(T1521584048.`report_date`) = 12
- AND WEEKOFYEAR(T1521584048.`report_date`) = 1 THEN
- YEAR(DATE_ADD(T1521584048.`report_date`,
- INTERVAL 1 year))
- ELSE YEAR(T1521584048.`report_date`)
- end, '-', CASE
- WHEN WEEKOFYEAR(T1521584048.`report_date`) <
- 10 THEN
- CONCAT
- (
- '0',
- WEEKOFYEAR(
- T1521584048.`report_date`))
- ELSE WEEKOFYEAR(T1521584048.`report_date`)
- end) >= '2014-03'
- AND CONCAT(CASE
- WHEN MONTH(T1521584048.`report_date`) = 1
- AND WEEKOFYEAR(T1521584048.`report_date`) > 50
- THEN
- YEAR(DATE_ADD(T1521584048.`report_date`,
- INTERVAL -1 year)
- )
- WHEN MONTH(T1521584048.`report_date`) = 12
- AND WEEKOFYEAR(T1521584048.`report_date`) = 1
- THEN
- YEAR(DATE_ADD(T1521584048.`report_date`,
- INTERVAL 1 year))
- ELSE YEAR(T1521584048.`report_date`)
- end, '-', CASE
- WHEN
- WEEKOFYEAR(T1521584048.`report_date`) < 10
- THEN
- CONCAT(
- '0',
- WEEKOFYEAR(
- T1521584048.`report_date`))
- ELSE
- WEEKOFYEAR(T1521584048.`report_date`)
- end) <= '2014-41' )
- OR ( CONCAT(CASE
- WHEN MONTH(T1521584048.`report_date`) = 1
- AND WEEKOFYEAR(T1521584048.`report_date`) > 50
- THEN
- YEAR(DATE_ADD(T1521584048.`report_date`,
- INTERVAL -1 year))
- WHEN MONTH(T1521584048.`report_date`) = 12
- AND WEEKOFYEAR(T1521584048.`report_date`) = 1 THEN
- YEAR(DATE_ADD(T1521584048.`report_date`,
- INTERVAL 1 year))
- ELSE YEAR(T1521584048.`report_date`)
- end, '-', CASE
- WHEN WEEKOFYEAR(T1521584048.`report_date`) <
- 10 THEN
- CONCAT
- (
- '0',
- WEEKOFYEAR(
- T1521584048.`report_date`))
- ELSE WEEKOFYEAR(T1521584048.`report_date`)
- end) >= '2015-02'
- AND CONCAT(CASE
- WHEN MONTH(T1521584048.`report_date`) = 1
- AND WEEKOFYEAR(T1521584048.`report_date`) > 50
- THEN
- YEAR(DATE_ADD(T1521584048.`report_date`,
- INTERVAL -1 year)
- )
- WHEN MONTH(T1521584048.`report_date`) = 12
- AND WEEKOFYEAR(T1521584048.`report_date`) = 1
- THEN
- YEAR(DATE_ADD(T1521584048.`report_date`,
- INTERVAL 1 year))
- ELSE YEAR(T1521584048.`report_date`)
- end, '-', CASE
- WHEN
- WEEKOFYEAR(T1521584048.`report_date`) < 10
- THEN
- CONCAT(
- '0',
- WEEKOFYEAR(
- T1521584048.`report_date`))
- ELSE
- WEEKOFYEAR(T1521584048.`report_date`)
- end) <= '2015-40' ) ))
- GROUP BY CONCAT(CASE
- WHEN MONTH(T1521584048.`report_date`) = 1
- AND WEEKOFYEAR(T1521584048.`report_date`) > 50 THEN
- YEAR(DATE_ADD(T1521584048.`report_date`, INTERVAL -1 year))
- WHEN MONTH(T1521584048.`report_date`) = 12
- AND WEEKOFYEAR(T1521584048.`report_date`) = 1 THEN
- YEAR(DATE_ADD(T1521584048.`report_date`, INTERVAL 1 year))
- ELSE YEAR(T1521584048.`report_date`)
- end, '-', CASE
- WHEN WEEKOFYEAR(T1521584048.`report_date`) < 10
- THEN CONCAT(
- '0',
- WEEKOFYEAR(
- T1521584048.`report_date`))
- ELSE WEEKOFYEAR(T1521584048.`report_date`)
- end)
- LIMIT 10000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement