Question

RIT Dep. Department of Information Sciences and Technologies Com 12. What equipment has never been used on a trip? | equipid l equipmentname Trips 3644 | Boeing 767 1 row in set (0.00 sec) 1 by sel> ms the period of 9/1/2017 through 10/31/2017, what types of transportation had more than typename NumTrips | Plane 21 1 row in set (0.20 sec) mysql> Submitting your work Take sure the "-Verbose" option is turned in before you start to create the tee file. If you don't know erbose on please see the Professor. must be at the command prompt so you can "source" your.sql file. ql>tee Habermas_Jim_PE01.txt he MySQL command "tee" (see above) to create log file after you are completely done with are no syntax errors in your sql file. must enter 4 comments at the top of your tee file. > tee Lastname_Firstname_PE01.txt mame (Lastname, Firstname format) 's date 30.01

Answer 1

12.

SELECT EquipID, EquipmentName FROM equipment WHERE EquipID NOT IN (SELECT EquipId FRO trip);

13.

SELECT tc.TypeName, count(distinct td.TripNum) AS NumTrips FROM trip_directory td JOIN tripcodes tc on tc.TripType = td.TripType;