Basic computer science question
Question Description
I’m working on a computer science question and need guidance to help me learn.
(1) You need to create two new tables: newemp, newdept
(2) Load data of emp to newemp, load data of dept to newdept
(3) List Employees earn more than average: You need to use subquery, SELECT … FROM …. WHERE …. (SELECT AVG(…) FROM…)
(4) List employee names, their department names and department numbers: You need to use Join operation to find data from newemp and newdept.
Slide 1 of 1
-
attachment_1attachment_1
Unformatted Attachment Preview
MySQL Practices ?1?
Create a New Employee Table (newemp)
Create a New Department Table (newdept)
Load data to New Employee Table (newemp)
Load data to New Department Table (newdept)
List names of all employees who are not from Department A00.
Which employees earn more than average?
List employee names, their department names and department numbers.
Purchase answer to see full
attachment
Create a New Employee Table (newemp)
Create a New Department Table (newdept)
Load data to New Employee Table (newemp)
Load data to New Department Table (newdept)
List names of all employees who are not from Department A00.
Which employees earn more than average?
List employee names, their department names and department numbers.
Purchase answer to see full
attachment
Explanation & Answer:
4 Questions
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with our honor code & terms of service.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
