微软 数据科学面试

SQL题目：
TableA - CustomerId, Industry, Area, Sales
TableB - CustomerId, Tenure
Q1: Find the total Sales by Industry
Q2: Find the median sales by Industry
我的答案：
SELECT industry, AVG(sales) AS median
  FROM
  (
  SELECT industry, sales,
  ROW_NUMBER() OVER (PARTITION BY industry ORDER BY sales ASC) AS row_num_asc, ROW_NUMBER() OVER (PARTITION BY industry ORDER BY sales DESC) AS row_num_desc
  FROM tableA
  ) AS temp
  WHERE row_num_asc IN (row_num_desc, row_num_desc  - 1, row_num_desc +

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

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

)*P(A) / P(B)
There are 3 ants sitting on three corners of a triangle. All ants randomly pick a direction and start moving along edge of the triangle. What is the probability that any two ants collide?
我的答案：
2^3 = 8
6/8

题目和答案全都附送给大家了！求加米啊各位仁兄和小仙女们！加米不扣自己大米！在此谢过！

我觉得找中位数用percentile_cont或者tile的window function更简单，直接得到结果

就一轮吗

非常感谢🙏

蚂蚁那题我觉得是1/4？

楼主，请问申请的岗位是什么名字？