Have a Question ?

Home / Answered Questions / Other / i-need-help-with-these-in-sql-please-1-give-a-list-of-employees-as-emp-firstname-emp-lastname-and-th-aw700

(Solved): I Need Help With These In SQL, Please :) 1.Give A List Of Employees (as Emp_FirstName, Emp_LastName)...


Customer Saleltem Product Manufacturer Customer D - SaleID ProductID FirstName ProductID ProductName Sale SaleID SaleDate Cus

I need help with these in SQL, please :)

1.Give a list of employees (as Emp_FirstName, Emp_LastName) and their hire dates (as Emp_HireDate) and their Managers (as Mgr_FirstName, Mgr_LastName). Also include the managers hiredates (as Mgr_HireDate) Name the columns as indicated. Only show names and hire dates.

2.List the customer first name and last name and the number of orders (name the column NumberOfOrders). List all customers even if they have never placed an order. Order the output by number of orders.

Customer Saleltem Product Manufacturer Customer D - SaleID ProductID FirstName ProductID ProductName Sale SaleID SaleDate CustomerID Tax Shipping Item Size LastName Street Address ManufacturerID Composition ManufacturerID O ManufacturerName Address1 Address2 City Quantity Sale Price ListPrice Gender State City State Postal Code Country Employee PostalCode Category Color EmployeelDO Phone Phone FirstName Fax Description SalaryEmployee Contact URL Employeeld Salary LastName Address City State ZIP Phone ManagerID SSN WageEmployee Employeeld 0 Wage MaxHours Email Address Hire Date


We have an Answer from Expert View Expert Answer

Expert Answer


We have an Answer from Expert
Buy This Answer $5

-- OR --

Subscribe To View Unlimited Answers
Subscribe $12 / Month