Assignment Submission This is an individual assignment no group submissions are

Question

Assignment Submission This is an individual assignment no group submissions are allowed. Submit a script file that contains the 12 SQL statements and their outputs from MySQL server to the corresponding assignment should appear at the beginning of the SQL script file. The outline of this SOL script file is as follows: link. Your nam e, class ID, and Date * Name: YourNameGoesHere Class: CST 225 * Date: * I have not received or given help on this assignment: YourNameAgain* Queries SELECT... KR*outpu

Explanation / Answer

Hi,

Ans 2-
select distinct empID,firstName,lastName from Employee;

Ans 3-
select distinct firstName,lastName,salary from Employee where salary>80000;

Ans 4 -
select distinct firstName,lastName,salary from Employee where salary between 100000 and 200000;

Ans 5-
select distinct name as DeptName,manager from Department;

Ans 6-
select distinct name as DeptName,manager from Department order by DeptName;

Ans 7-
select distinct name as Department,concat(firstName,lastName) as "Manager Name" from Department ;

Ans 8-
select distinct firstName,lastName,DeptID from Employee;

Ans 9-
select distinct firstName,lastName,DeptName from Employee e join department d on e.deptID=d.deptID;

Ans 10-
select distinct firstName,lastName,salary from Employee e join department d on e.deptID=d.deptID and DeptName='Information Technology';

Ans 11-
select avg(salary) as "Average Salary" from Employee;

Ans 12-
select distinct DeptName as "Department Name", avg(salary) as "Average Salary" from Employee e join department d on e.deptID=d.deptID group by DeptName;

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.