我在大查询中有两个表,下面是每个表的图像表示\
我想要的是通过将相应的Land URL分组来汇总点击次数。以下是我正在使用的查询,但未返回任何结果
Select a.quarters as Quarters, sum(b.clicks) as Clicks
from `spreadsheetapi-1147.FlosportsDatabase.GroupByColumnReference` as a
inner join `spreadsheetapi-1147.FlosportsDatabase.kenshoo` as b
on lower(a.quarters) like concat('%' , b.land_url , '%' )
group by a.quarters
开关lower(a.quarters)
并b.land_url
进行LIKE检查
Select a.quarters as Quarters, sum(b.clicks) as Clicks
from `spreadsheetapi-1147.FlosportsDatabase.GroupByColumnReference` as a
inner join `spreadsheetapi-1147.FlosportsDatabase.kenshoo` as b
on b.land_url like concat('%' , lower(a.quarters) , '%' )
group by a.quarters
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句