Access over 35 million academic & study documents

Display all records of employees who work in the Finance department

Content type
User Generated
Rating
Showing Page:
1/2
Display all records of employees who work in the Finance
department: SELECT emp_id, emp_name, salary, dept_id
FROM employee join department ON dept_id=dept_id
WHERE dept_name=\'Finance\'; SELECT emp_id,
emp_name, salary, dept_id FROM employee department
WHERE employee.dept_id=department.dept_id AND
WHERE dept_name=\'Finance\'; SELECT emp_id,
emp_name, salary, dept_id FROM employee AND
department WHERE
employee.dept_id=department.dept_id AND
dept_name=\'Finance\'; SELECT emp_id, emp_name,
salary, employee.dept_id FROM employee join department
ON employee.dept_id=department.dept_id WHERE
dept_name=\'Finance\'; C or D Group records by dept-
name; Display the Department name and total salary
earned by all employees working in the Finance
department. SELECT dept_name, COUNT(salary) FROM
employee JOIN department ON
employee.dept_id=department.dept_id WHERE
dept_name=\'Finance\'; SELECT dept_name, SUM(salary)
FROM employee JOIN department ON
employee.dept_id=department.dept_id WHERE
dept_name=\'Finance\'; SELECT dept_name,
COUNT(salary) FROM employee JOIN department ON
employee.dept_id=department.dept_id WHERE
dept_name=\'Finance\'; GROUP BY dept_name;
Solution
27. the answer is d.

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/2

Sign up to view the full document!

lock_open Sign Up
Unformatted Attachment Preview
Display all records of employees who work in the Finance department: SELECT emp_id, emp_name, salary, dept_id FROM employee join department ON dept_id=dept_id WHERE dept_name=\'Finance\'; SELECT emp_id, emp_name, salary, dept_id FROM employee depart ment WHERE employee.dept_id=department.dept_id AND WHERE dept_name=\'Finance\'; SELECT emp_id, emp_name, salary, dept_id FROM employee AND department WHERE employee.dept_id=department.dept_id AND dept_name=\'Finance\'; SELECT emp_id, emp_name, salary, employee.dept_id FROM employee join department ON employee.dept_id=department.dept_id WHERE dept_n ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Really helped me to better understand my coursework. Super recommended.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4