zillow 店面 求大米

求大米 求大米！求大米！


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
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
+----------+-------------+----------+
| AgentID  | Month       | Spend    |
+----------+-------------+----------+
|

您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

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
group by 1