『拼多多』数据分析岗面经!(含参考答案)
2024-07-31 05:36:460 次浏览
投稿
SELECT int_q1_value+(int_q1_next_value-int_q1_value)*decimal_q1_place AS q1 ,int_q2_value+(int_q2_next_value-int_q2_value)*decimal_q2_place AS q2 ,int_q3_value+(int_q3_next_value-int_q3_value)*decimal_q3_place AS q3FROM( SELECT -- Q1的相关数据 MAX(if(int_q1_place = b.rn,order_cnt,NULL)) AS int_q1_value ,MAX(if(int_q1_place+1 = b.rn,order_cnt,NULL)) AS int_q1_next_value ,MAX(decimal_q1_place) AS decimal_q1_place -- Q2的相关数据 ,MAX(if(int_q2_place = b.rn,order_cnt,NULL)) AS int_q2_value ,MAX(if(int_q2_place+1 = b.rn,order_cnt,NULL)) AS int_q2_next_value ,MAX(decimal_q2_place) AS decimal_q2_place -- Q3的相关数据 ,MAX(if(int_q3_place = b.rn,order_cnt,NULL)) AS int_q3_value ,MAX(if(int_q3_place+1 = b.rn,order_cnt,NULL)) AS int_q3_next_value ,MAX(decimal_q3_place) AS decimal_q3_place FROM ( -- 位置取整数和小数部分 SELECT FLOOR(q1_place) AS int_q1_place ,q1_place-floor(q1_place) AS decimal_q1_place ,FLOOR(q2_place) AS int_q2_place ,q2_place-floor(q2_place) AS decimal_q2_place ,FLOOR(q3_place) AS int_q3_place ,q3_place-floor(q3_place) AS decimal_q3_place FROM ( -- 位置 SELECT MAX(rn) AS n -- 样本数 ,(MAX(rn)+1)*0.25 AS q1_place ,(MAX(rn)+1)*0.50 AS q2_place ,(MAX(rn)+1)*0.75 AS q3_place FROM user_order_rn )a )a INNER JOIN user_order_rn b ON 1 = 1 -- 笛卡尔乘积)a▍Tips:无论是社招还是校招,笔试还是面试拼多多均会重点考察SQL题
且相比其他大厂,拼多多对SQL的要求较高
所以,请务必熟练熟练再熟练!
二、机器学习&概率论 ▌面试真题1: 模型过拟合怎么处理
★参考答案模型过拟合主要可以从以下几个方面入手
获取