Just press the “Order now” button and let the system intuitively guide you through the process.
As the world’s best bespoke custom essay writing solutions company, we offer below services
SQL – Discussion – Question
Formulate the following queries:
1, List the name of project that has MOST of employees working on it. (hint: use group by and having with subquery )
2. List the name of division that has more employees whose salary is above the divisional average salary than any other divisions.
3. Increase the salary of division manager by 1% if he/she works on other division’s project (hint: need a co-related condition )
4. List the total number of employees from Chen’s division who work with Chen on project development. (note if a Chen’s divisional colleague works on more than one projects with Chen, this colleague should be only count once.
5. For each project, list the name of project, and (1) the total number of employee working on it, (2 )the total number of employees who work on it but from other division (not the division that sponsors this project), and (3) the total number of employee who work on it and are from the same division that sponsors this project. Hint, the structure of your code is as follows
Select pname ,
(a select statement that returns data in (1)) total,
( a select statement that returns data in (2)) outsiders,
(a select statement that returns data in (3)) insiders
The papers we provide serve as model papers for research candidates and are not to be submitted ‘as is’. These papers are intended to be used for reference purposes only. We only offers consultation and research support and assistance in research design, editing, and statistics.
+254 769 316 835