d**f
发帖数: 264 | 1 1. A table schema with tables like employee, department, employee_to_
department, project, employee_to_project
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
2. Table has two data entries every day for number of apples and oranges
sold. write a query to get the difference between the apples… |
|
