You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT res0.field_1 AS field_1, res0.field_0 AS field_0
FROM (
SELECT applyFormula.field_1 AS field_1,
SUM(applyFormula.field_0) AS field_0
FROM (
SELECT DISTINCT CASE
WHEN (view.yuyi992388116796932096 IN
('1'))
THEN ('862074450957303808')
WHEN (view.yuyi992388116796932096 IN
('2')) THEN ('966790116192288768')
WHEN (view.yuyi992388116796932096 IN
('3')) THEN ('862074476827770880')
WHEN (view.yuyi992388116796932096 IN
('4)) THEN ('915985128101273600')
END AS field_1,
COUNT(view.yuyi992388116801126400) AS field_0
FROM (
select subQuery0.yuyi992388116801126400 as yuyi992388116801126400, subQuery0.yuyi992388116880818176 as yuyi992388116880818176, subQuery0.yuyi992388116796932096 as yuyi992388116796932096
from ( select custom_label.label_id as yuyi992388116801126400, dwd_dialog_info2. dialog_id as yuyi992388116880818176, dwd_dialog_info2. wangwang as yuyi992388116796932096
from dwd_dialog_info dwd_dialog_info2
ARRAY JOIN custom_label.label_id
where (dwd_dialog_info2.date between '2022-06-14' AND '2022-06-14' AND
(dwd_dialog_info2.wangwang IN
('5') AND dwd_dialog_info2.company_id = 277)) ) subQuery0
) AS view
GROUP BY field_1
) AS applyFormula
GROUP BY field_1
) AS res0
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
SELECT
res0
.field_1
ASfield_1
,res0
.field_0
ASfield_0
FROM (
SELECT
applyFormula
.field_1
ASfield_1
,SUM(
applyFormula
.field_0
) ASfield_0
FROM (
SELECT DISTINCT CASE
WHEN (
view
.yuyi992388116796932096
IN('1'))
THEN ('862074450957303808')
WHEN (
view
.yuyi992388116796932096
IN('2')) THEN ('966790116192288768')
WHEN (
view
.yuyi992388116796932096
IN('3')) THEN ('862074476827770880')
WHEN (
view
.yuyi992388116796932096
IN('4)) THEN ('915985128101273600')
END AS
field_1
,COUNT(
view
.yuyi992388116801126400
) ASfield_0
FROM (
select
subQuery0
.yuyi992388116801126400
asyuyi992388116801126400
,subQuery0
.yuyi992388116880818176
asyuyi992388116880818176
,subQuery0
.yuyi992388116796932096
asyuyi992388116796932096
from ( select
custom_label.label_id
asyuyi992388116801126400
,dwd_dialog_info2
.dialog_id
asyuyi992388116880818176
,dwd_dialog_info2
.wangwang
asyuyi992388116796932096
from dwd_dialog_info
dwd_dialog_info2
ARRAY JOIN
custom_label.label_id
where (
dwd_dialog_info2
.date
between '2022-06-14' AND '2022-06-14' AND(
dwd_dialog_info2
.wangwang
IN('5') AND
dwd_dialog_info2
.company_id
= 277)) )subQuery0
) AS
view
GROUP BY
field_1
) AS
applyFormula
GROUP BY
field_1
) AS
res0
Beta Was this translation helpful? Give feedback.
All reactions