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 languages
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
Get step-by-step solutions from verified subject matter experts
