DataV报表流程

SELECT round((t1.`value`-t2.`value`)/t2.`value`*100,2) as `value` FROM
  (SELECT average_year as `value` FROM kpi_baidu_index_month_summary
  WHERE search_year = year(now()) AND keyword = '微整' 
  GROUP BY keyword ) as t1
LEFT JOIN 
  (SELECT average_year as `value` FROM kpi_baidu_index_month_summary
  WHERE search_year = year(now())-1 AND keyword = '微整' 
  GROUP BY keyword) as t2
on 1=1

SELECT concat(t1.`month`,'月') as x,ifnull(t2.average_month,0) as y,t1.month_en_short,t3.keyword as s
FROM (select * from dim_date WHERE time_type = 'month' and `year` = year(now())) AS t1
LEFT JOIN(SELECT keyword FROM dim_baidu_index_keyword WHERE LOCATE(keyword,'粉毒,衡力,botox') > 0) as t3
on 1=1
LEFT JOIN (SELECT * from kpi_baidu_index_month_summary WHERE LOCATE(keyword,'粉毒,衡力,botox') > 0) AS t2
  ON t1.`year` = t2.search_year AND t1.`month` = t2.search_month AND t2.keyword = t3.keyword
ORDER BY t1.`month`;