Chapter 9 Lab - working with data types and functions(1)

Chapter 9 Lab – Working with data types and functions Name: __Lesly Mendoza______________ Date: 10/18/23___________________ ------------------------------------------ 3. Write a select that list each engineer’s name, and how many years the engineer has worked for the Eagle Corporation. Paste below the code you wrote and the run results you obtained for this exercise: SELECT CONCAT ( FirstName , ' ' , LastName ) AS EngineerName , DATEDIFF ( year , HireDate , GETDATE ()) AS YearsWithCompany FROM Employee WHERE JobTitle = 'Engineer'

Chapter 9 Lab – Working with data types and functions Name: __Lesly Mendoza______________ Date: 10/18/23___________________ SELECT C . CompanyName , CONCAT ( DATENAME ( month , CO . OrderDate ), ' ' , DAY ( CO . OrderDate ), ',' , YEAR ( CO . OrderDate )) AS OrderDate FROM Customer C , CustOrder CO WHERE C . CustomerID = CO . CustomerID AND MONTH ( CO . OrderDate ) = 10 AND C . CompanyName IS NOT NULL AND C . CompanyName NOT LIKE 'F%' ORDER BY C . CompanyName DESC ------------------------------------------ 7. Write a select that produces a list that shows the Customer FirstName, LastName, and Phone of each of eagles non-corporate customers that has ordered something during a month of October (year does not matter).Hint: A non-corporate customer has a null value for company name. Paste below the code you wrote and type the number of rows returned for this exercise: SELECT C . CustFirstName , C . CustLastName , C . Phone FROM Customer C , CustOrder CO WHERE C . CustomerID = CO . CustomerID AND MONTH ( CO . OrderDate ) = 10