Question: Hi this is a databse question. This is a part of the big question. Please answer all of them as this is the third time

Hi this is a databse question. This is a part of the big question. Please answer all of them as this is the third time i am posting. this is sql language. do not use other programming languagesHi this is a databse question. This is a part of the

11. Write an SQL to show the project name and the corresponding employee names as shown below - project_name I group_concat(employee .emp_fnane) : evergreen I june, david amber wave I John, june,william rolling tide | alice starlight I william 12. Write an SQL code to show output to show employee name, employee hire date, job description and job charge hour 13. Write an SQL code to show all the employees (with employee id) in each project. 14. Write an SQL code to show the employees (with employee id) of project - 'evergreen' 15. Write an SQL code to show all the assignments of a System Analyst. 16. Show all the projects where the assignment date is greater than 2009-09-01' 17. Write a query to show the employee name, assigned hours, assigned charges and project name for the 'programmer

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!