1.平均时间
2.CI计算
3.MLE计算
4.R Dataframe
5.去过的人的预期计算
6.零件预测
7.Easy SQL Problem
8.SQL vs NoSQL
9.Normalize a JSON-like Structure
10.Find Subarray Start Intervals of Ones
11.Calculate Differences Between Consecutive Elements
12.Server Status Query
13.Count Reserved Tickets
14.Calculate the first ineligible date for each car that was cancelled or not delivered
15.Calculate the weekly delivery rate for a specific car model this year
16.Calculate the number of users who placed orders for at least one model
17.Calculate Test Scores as Percentage
18.Minimize Deletion Cost to Avoid Repeating Letters
19.Minimize Operations to Avoid Consecutive Characters
20.Interleave Digits of an Integer
21.Maximum Instances of 'balloon' from a String
22.Minimum Coin Flips for Alternating Sequence
23.Selecting Employee Names with Their Manager's Name
24.Selecting Customers Without Orders
25.Coding Challenges
26.Tableau Optimization
27.Simple Linear Regression Function
1. 平均时间
table: car
field:id,zone，timestamp，model
id是key
zone是每个车生产经历的阶段，1，2，3，4...
timestamp是时间点，每个zone会经历多个时间点，比如2017/02/13/18：50（精确到分钟），
model是车的型号
问题：所有车停留在zone=3的平均时间，每个model停留在zone=3的平均时间
2. CI计算
100个抽样，55通过求估计及confidence interval；追加：用t还是z
3. MLE计算
推导exponential distribution的MLE
4. R Dataframe
R coding，简单考你会不会一些data frame的method，需要用到dplyr
5. 去过的人的预期计算
概率题：一个班100个人，问周末谁去了球塞，55人举手；举手规则如下：投硬币一次，head的人照实举手或者不举手，tail的人投第二次，第二次head就举手tail则不举手问真正去过的人的期望是多少
解锁更多真题，请点此 登录 篱笆帮
高频题（0）
