注册一亩三分地论坛,查看更多干货!
您需要 登录 才可以下载或查看附件。没有帐号?注册账号 
x
求大米 求大米!求大米!
.google и
Zillow 店面
Q1 things in either left table or right table but not in both .--
. ----
select *
from t1
Full outter join t2 on t1.id=t2.id
where true
And t1.id is null or t2.id is null -baidu 1point3acres
limit 100;
/*
Real estate agents purchase our advertising product, Premier Agent, on a monthly basis. Let’s assume we have a table named AgentSpend which stores {AgentID, Month, Spend}.
*/
AgentSpend. Χ
+----------+---rior_month_spend and prior_month_spend > 0 then spend end) as mod-up,
sum( case when prior_month_spend>0 and spend=0 then spend end) as cancel,. .и
sum( case when spend<prior_month_spend and spend>0 then spend end) as mod-down,
from t1
where true .1point3acres
group by 1
..
|