每日一练 | Data Scientist & Business Analyst 面试题 173

大数据应用 · 公众号 · 大数据 · 2017-08-27 09:03

正文

从6月15日起，数据应用学院将与你一起温习数据科学（DS）和商业分析（BA）领域常见的面试问题。希望积极寻求相关领域工作的你每天关注我们的问题并且与我们一起思考，我们将会在第二天给出答案。

Day 73

DS Interview Questions

How do you understand the term Normal Distribution?

BA Interview Questions

SQL: Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID.

The STUDENTS table is described as follows:

The Name column only contains uppercase (A-Z) and lowercase (a-z) letters.

Sample Input:
Sample Output:
Ashley
Julia
Belvet

欲知答案如何？请见下期分解！

Day 72 答案揭晓

DS Interview Questions

What’s the differences between the Poisson distribution and normal distribution?

A Poisson distribution is discrete while a normal distribution is continuous
A Poisson random variable is always >= 0.
When the mean of a Poisson distribution is large, it becomes similar to a normal distribution.

BA Interview Questions

SQL: Write a query that prints a list of employee names (i.e.: the name attribute) for employees in Employee having a salary greater than per month who have been employees for less than months. Sort your result by ascending employee_id.

The Employee table containing employee data for a company is described as follows:

where employee_id is an employee's ID number, name is their name, months is the total number of months they've been working for the company, and salary is the their monthly salary.

Sample Input：