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)...
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 $6
Buy This Answer $6
-- OR --
Subscribe To View Unlimited Answers
Subscribe $20 / Month
Subscribe $20 / Month