Using Northwind: USE MICROSOFT SQL SERVER Create a query selecting the Manager first name, last name, employee first name, last name.  Group by the manager (list the manager only one time), sort the employees within their managers.

7. What gift will a customer who orders the book Shortest Poems receive? Use the actualbook retail value to determine the gift.

Based on the given table. Customer ID Name Balance Payment 193 Chen 2100 300 584 Ravindran 5000 250 231 Bolt 300 20 608 Gomez 950 125 What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM Customer; 3900, 9750, 590, 1775 3600 3600, 9500, 560, 1650

Write a query that uses INNER JOIN TO connect the EMPLOYEE, EMPPROJACT, PROJACT and PROJECT tables.   Include the Project number , Department number, Project start and end date and AC STAFF  WHERE They belong to department D11 , Salary is more than or equal to 65 percent of $15,000 AND Salary is less than or equal to 130 percent of $40,000