Facebook Interview Question
Data EngineersTeam: Search
Country: United States
Interview Type: Phone Interview
Suppose we have 2 tables
table employee: employeeid , employeename
table department: departmentid, departmentname
table depemp: employeeid, departmentid
now run
select count(*), employeename from employee a, department b, depemp c where a.employeeid=c.employeeid and b.departmenetid=c.departmentid group by employeename
thanks for sharing, do you have any advice where to prepare for data engineer interview in facebook ? also in onsite interview focus is more on SQL part or coding (whiteboard) ?
- nikhil April 17, 2017