Facebook Interview Question: SQL questions - A table schem...
Interview question for Data Engineer in San Francisco, CA.SQL questions - A table schema with tables like employee, department, employee_to_projects, projects 1) Select employee from departments where max salary of the department is 40k 2) Select employee assigned to projects 3) Select employee which have the max salary in a given department 4) Select employee with second highest salary 5) Table has two data entries every day for # of apples and oranges sold. write a query to get the difference between the apples and oranges sold on a given day
Interview question for Data Engineer in San Francisco, CA.SQL questions - A table schema with tables like employee, department, employee_to_projects, ...