Using the data below, make SQl statements. Please label each question.

1. Who are the employees that their emp_title contains the word freight?  Display their full name and their title.
2. Who are the employees who have been hired in the years of 2000 to 2010?
3. How many products appear on each invoice? Display the inv_num, prod_SKU and an aliased suitable new column name.
4. Show the employees who have issued any invoices: Display the inv_num, inv_date, employee first and last name.
5. Show the employees (emp_num, first and last name) only once, if they were issued any invoices.
6. What invoice has the highest amount? Display the inv_num and an alias name 'highest_amount'.
7. Apply an increase of 15% in addition to the current Line Price: show the line_num and an alias name for calculated column 'Increased_price'.
8. Write an SQL statement to change the phone number for employee 'Long Willard' to 245-8899.

 

Line Table INV NUM LINE NUM PROD SKU LINE QTY LINE PRICE 104 6041-PBS 2 7.49 104 8523-UCB 1 21.59 6451-KGJ 1 6.99 6.59 8941-JFP 1 11.99 9324-PPG 2 6350-UPP 3 1838-421 3 1504-LVK 3 1074-VV3 1 7627+HI 1 6933-YOU 5 7158-4.JP 2 8726-ZNM 3 5642-IDA 2 5445-XOY 5 4 3503-FGI 3036-PCT 6249-NON 1 5 8937-WVA 5 104 105 106 106 106 106 107 107 108 108 108 109 109 109 109 109 109 110 110 110 110 110 111 1 2 83341 83347 83349 83359 83366 83371 83371 83372 83374 83378 3 1 1 2 83382 83385 4 1 2 1 2 3 1 2 3 4 5 6 1 2 3 4 S 83304 83308 83312 83314 83318 83321 83332 WILLARD 2455-201 3 5980-BME 1 5541HST 2 3610-RKR 5 8841-JFP 3 2553-FSW 5 BAKER CHAROLETTE DAVID PECK Employee Table EMP_NUM EMP FNAME EMP UNAME EMP EMAIL TAMARA MCDONALD LOVE CONNIE ROSALBA DARCIE ANGELINA FARMER LONG CHRISTINE CORTEZ WINN JENNIFFER SINGH QUINTIN WATTS BLEDSOE MATHEWS MATHEWS MERLE PHOEBE 12.49 12.59 21.99 23.29 11.59 8.99 ROXANE ROXANE CLAUDINE DAHL DARRON TILLEY FELICIA DUNHAM STELLA CONKLIN BRODERICK COLBERT 11.99 21.99 29.99 10.99 5.59 3.99 22.59 3.29 38.99 31.99 32.99 18.59 6.59 20.59 Invoice Table INV NUM INV_DATE CUST_CODE INV_TOTAL EMPLOYEE_ID 104 2017-01-30 88 105 2017-01-30 89 106 2017-01-30 90 107 108 109 110 111 112 113 114 115 116 117 118 GR628BE6665 119 120 121 122 123 124 127 2017-01-30 91 2017-01-30 92 2017-01-30 93 2017-01-31 94 2017-01-31 95 2017-01-31 96 2017-01-31 97 2017-01-31 98 99 2017-01-31 2017-01-31 2017-01-31 2017-01-31 2017-02-01 2017-02-01 2017-02-01 2017-02-01 2017-02-01 100 ESSESR525558 101 102 103 104 105 106 107 2017-02-01 108 2017-02-01 109 2017-02-01 110 2017-02-02 111 2010-10-20 T.MCDONA3@PRIMEPAINTS.COM 453-9342 C.LOVE 77@PRIMEPAINTS.COM 495-3082 R.BAKER9@PRIMEPAINTS.COM 632-8197 1984-12-15 2016-12-12 C.DAVID84@PRIMEPAINTS.COM 726-5086 1991-02-17 D.PECK4@PRIMEPAINTS.COM 680-6124 2011-05-03 A.FARMER86@PRIMEPAINTS.COM 734-7097 1993-09-08 W.LONG1@PRIMEPAINTS.COM 242-1979 2008-03-08 C.CORTEZ85@PRIMEPAINTS.COM 508-3269 1992-07-28 Q.WINN82@PRIMEPAINTS.COM 653-6753 1989-08-25 J.SINGH87@PRIMEPAINTS.COM 722-9727 1994-01-07 M.WATTS90@PRIMEPAINTS.COM 406-3691 1997-10-22 P.BLEDSO99 @PRIMEPAINTS.COM 686-7916 2006-08-14 R.MATHEW94@PRIMEPAINTS.COM 512-3569 2001-08-08 R.MATHEW94@PRIMEPAINTS.COM 512-3569 2001-08-08 C.DAHL90@PRIMEPAINTS.COM 326-1880 1997-10-29 2008-10-04 2012-12-31 D.TILLEY1@PRIMEPAINTS.COM 305-1308 F.DUNHAMS@PRIMEPAINTS.COM 255-9624 S.CONKLI80@PRIMEPAINTS.COM 511-5282 B.COLBER91@PRIMEPAINTS.COM 888-6311 43.56 6.59 1987-03-28 1998-11-25 165.19 34.88 496.38 196.28 327.66 422.63 507.43 449.24 278.93 163.95 261.83 24.99 372.46 243.80 47.07 154.71 29.98 321.20 81.94 197.98 58.15 175.90 83734 83734 84134 836-49 84134 83734 83792 84021 83820 84334 84420 83878 84392 84191 83820 83677 83649 83593 83906 84248 84364 83734 EMP PHONE EMP_HIREDATE EMP_TITLE ASSOCIATE SENIOR ASSOCIATE ASSOCIATE ASSOCIATE FREIGHT STOCKER BRAND ASSOCIATE BRAND ASSOCIATE HULL ASSOCIATE NULL SENIOR FREIGHTER SENIOR FREIGHTER GULL NULL SENIOR ASSOCIATE ASSOCIATE FREIGHT STOCKER FREIGHT STOCKER DRIVER FREIGHT STOCKER ASSOCIATE ASSOCIATE FREIGHT STOCKER 83509 83878 EMP_COMM NULL NULL HULL NULL NULL NULL NULL HULL HULL NULL HULL HULL HULL HALL HULL DEPT_NUM 400 250 300 280 500 280 280 250 500 500 300 400 500 500 550 500 600 400 500