Microsoft SQL Server experts!! assist me in writing queries to achieve sample re
ID: 3728483 • Letter: M
Question
Microsoft SQL Server experts!! assist me in writing queries to achieve sample results!! I know this is a long shot but I really need the help for an upcoming assignment that is due soon. Assuming the following table exists in SQL, how do I write queries that achieve the following requirements:
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 JobTitleExplanation / Answer
A . SELECT EMPLOYEEID,JOBPOSITIONID,USERNAME,USERPASSWORD FROM TBLEMPLOYEE WHERE USERNAME = "ismhao9" and USERPASSWORD = "ism136ao9"
B . SELECT EMPLOYEEID,FIRSTNAME +' ' + LASTNAME AS EMPLOYEEFULLNAME, JOBPOSITIONID FROM TBLEMPLOYEE
C . SELECT JOBPOSITIONID,JOBTITLE FROM TBLJOBPOSITION ORDER BY JOBTITLE
D . SELECT EMPLOYEEID,LASTNAME +', ' + FIRSTNAME AS SUPERVISORNAME, JOBPOSITIONID FROM TBLEMPLOYEE ORDER BY SUPERVISORNAME
E . SELECT ORDERNO,ORDERDATE,FILLEDYESNO,EMPLOYEEIFFILLEDORDER WHERE EMPLOYEEIFFILLEDORDER = 75 OR EMPLOYEEIFFILLEDORDER IS NULL
F . SELECT ORDERNO,SUM(T2.QUANTITYORDERED) AS NOOFPRODUCTS FROM TBLCUSTOMERORDER T1, TBLORDERLINE T2 WHERE T1.ORDERNO = T2.ORDERNO GROUP BY T1.ORDERNO