MICROSOFT SQL SERVER: I need help writing queries that require joining tables ba

Question

MICROSOFT SQL SERVER: I need help writing queries that require joining tables based on the set of tables and requirements below:

tblAddress AddressID tblCompany CompanylD CompanyName BillingAddressID IsCustomer CustomerVenderSince DateLastModified tblProduct 9 ProductiD City StateProvince PostalCode Country ProductName CurrentStandardUnitPrice tblOrderLine tblCustomerOrder tblEmployee OrderNo EmployeelD LastName FirstName UserName UserPassword Phone SupervisorlD JobPositionlD OrderNo ProductID QuantityOrdered UnitPriceCharged DiscountRate QuantityPicked OrderDate FilledYesNo CompanylD ShippingAddressID EmployeelDTookOrder EmployeelDFilledOrder - tblJobPosition JobPositionID JobTitle

Explanation / Answer

SQL Queries for part-

a.

SELECT e.EmployeeID, CONCAT(e.FirstName, ' ', e.LastName) AS EmployeeFullName, e.JobPositionId, j.JobTitle FROM tbl_Employee e JOIN tbl_JobPosition j WHERE e.JobPositionI=j.JobPositionI AND e.EmployeeID=50

b.

SELECT e.EmployeeID, CONCAT(e.LastName, ', ', e.FirstName, ':' , j.JobTitle ) AS SupervisorName FROM tbl_Employee e JOIN tbl_JobPosition j WHERE e.JobPositionI=j.JobPositionI Order By e.LastName , e.FirstName;

c.

SELECT o.OrderNo, FORMAT(o.OrderDate, 'd', 'en-gb' ) AS OrderDate, o.CompanyID, c.CompanyName , o.FilledYesNo, o.EmployeeIdFilledOrder , COALESCE(e.LastName+ ', '+e.FirstName, 'None' ) AS EmployeeAssignedToFIll , COUNT(p.ProductID) FROM tbl_CustomerOrder o OUTER JOIN tbl_Employee e JOIN tbl_Company c JOIN tbl_OrderLine p j WHERE o.EmployeeIdFilledOrder=e.EmployeeId AND o.CompanyID=c.CompanyID AND o.OrderNo=p.OrderNo Order By o.OrderNo;

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.