登录
  • #面试经验
  • #数科面经

facebook infra DS 电面

一亩三分地匿名用户
722
3
上来面试官自我介绍后直接开始 没有任何我的自我介绍环节

1. SQL

The data of stores are organized in a table called “store” with id as the unique key of stores.

id | brand | revenue | cost

-----------------------------------

1 | Pizza Hut | 50.25 | 20.0

2 | Pizza Hut | 75.75 | 50.0

3 | KFC | 10.0 | 1.0

4 | Wing Street | 10.23 | 8.0

1) Find the ids of stores with revenue > 50.00

2) Find the id, brand, revenue, cost, and profit of the most profitable store

3) Find the total number of stores and total profit of each brand

The data of store locations are organized in a separate table called “state”.

id | state

-----------

1 | WA

2 | CA

3 | CA

4 | UT

4) Print all rows and fields along with the state.

5) Identify the most popular brand (the brand with the large

本帖隐藏的内容需要积分高于 188 才可浏览,点击前往一亩三分地论坛阅读

01 | 150

10002 | 101 | 2010-03-01 | 120

10003 | 102 | 2013-05-01 | 125

10004 | 103 | 2013-10-01 | 115

10005 | 103 | 2014-01-01 | 115

10006 | 101 | 2014-02-01 | 90

…...

I want to claim that experienced employees run their jobs more efficiently with shorter job running time, how do you confirm or reject this claim?
3条回复
热度排序

发表回复