Write a query that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance). Hint (use the AIRCRAFT table). Table name: CHARTERCHAR_TRIP CHAR_DATE AC_NUMBER CHAR_DESTINATION CHAR_DISTANCE CHAR_HOURS_FLOWN CHAR_HOURS_WAIT CHAR_FUEL_GALLONS CHAR_OL_QTS CUS_CODE Table name: EARNEDRATING10001 05-Feb-16 228910002 05-Feb-16 2778V10003 05-Feb-16 4278Y10004 06-Feb-16 1484P10005 06-Feb-16 228910006 06-Feb-16 4278Y1000706-Feb-16 2778V07-Feb-16 1484P100081000907-Feb-16 2289L1001007-Feb-16 4278Y1001107-Feb-16 1484P10012 08-Feb-16 2778V08-Feb-16 4278Y100131001409-Feb-16 4278Y10015 09-Feb-16 2289L10016 09-Feb-16 2778V10017 10-Feb-16 1484P10018 10-Feb-16 4278YTable name: CREWCHAR_TRIP EMP NUM CREW JOB10001104 P10002101 P10003105 P100031000410005100061000710007100081000910010100111001110012100131001410015100151001610016100171001810018109 Copilot106 Pilot101 P109 Pilot104 P105 Cop106 Plot105 Pilot100 Plot101 P104 Cop101 Po105 P106 Pilot101 Cop104 P105 Cop109 P101 P104 Copilot105 PilotATLBNAGNVSTLATLSTLGNVTYSGNVATLBNAMOBTYSATLGNVMOYSTLTVS10010 Ramas10011 Dunne10012 SmithTable name: AIRCRAFTAC_NUMBER MOD_CODE AC TTAF1484PPA23-2502209LC-90A2778VPA31-3504278YPA31-35010013 Clowski10014 Orlando10015 O'Brian10016 Brown10017 Williams10018 Farriss10019 Smith106 Mrs.107 Mr.108 Mr.109 Ms.110 Mrs.AC_TTEL AC_TTER936320157447210234721574644157499035288464493616453125086441833.1 1833.14243.0768.9799292147.31513.1622.1AlfredLeonaKathyPaulMyronAmyJamesGeorgeAnneOlette101.81123.4789.5243.2AKWFBK5.11.6782.95.72679Table name: CUSTOMERCUS_CODE CUS_LNAME CUS_FNAME CUS_INITIAL CUS_AREACODE CUS_PHONE CUS_BALANCE844-2573894-1238894-2285Table name: EMPLOYEEEMP NUM EMP TITLE EMP LNAME EMP_FNAME EMP_INITIAL100 Mr.KolmyczLewis101 Ms.102 MrVandam103 Ms.Jones104 Mr.Lange105 Mr.WilliamsDuzakDianteWesenbachTravisGenkaziGeorgeRhondaRhettAnneJohnRobertJeanineJorgePaulElizabethLeighia6.66.21.93.96.16.7153.13.8615713615615615713615615713615D0MPDKDRKW2200Table name: PILOTEMP_NUM PIL LICENSE101 ATP104 ATP105 COM106 COM109 COM4.93.55.20023.43.25.3424.52.10004.5894-2180222-1672442-3381297-1228290-2556382-7185297-3809354.172618-Jun-196119-May-1970339.897.2117.1348.4140.6459.9279.766.41PL_RATINGSATP/SELMELAnstr/CFIATP/SELMELAnstrCOMM/SELMELA/CFCOMMISELMELAnstrATPISELMEL/SESAnstr/CF 1122215.1174.3302.6459.5672105.5167 A0.000.00896.541285.19673.211014.560.000.000.00453.98EMP DOB15-Jun-194219-Mar-196514-Nov-1958 20-Dec-199216-Oct-1974 28-Aug-200508-Nov-1971 20-Oct-199614-Mar-197512-Feb-196821-Aug-197414-Feb-196602-Ju-199618-Nov-1994114-Apr-199101-Dec-199202120210010108-Jan-2006 PA31-35005-Jan-199102000CFICFIINSTRMELSELSES1001110016 EMP_NUM RTG_CODE EARNRTO_DATE10014100191001110017100121001410017100161001210010100111001710016100111001410017EMP HIRE DATE15-Mar-198725-Apr-1988 Table name: MODELTable name: RATINGRTG_CODERTO NAMECertified Flight InstructorCertified Flight Instructor, InstrumentInstrumentMutiengine LandPIL_MED_TYPE PIL_MED_DATE PL_PT135_DATE20-Jan-1618-Dec-1505-Jan-1610-Dec-1522-Jan-16101 CFI101 CFI101 INSTR101 MEL101 SEL104 INSTR104 MEL104 SEL105 CFI105 INSTR105 MEL105 SEL106 INSTR106 MEL106 SEL109 CFI109 CFSingle Engine, LandSingle Engine, Sea109 INSTR109 MEL109 SEL109 SES11-Jan-1617-Jan-1602-Jan-1602-Feb-1615-Jan-16MOD_CODE MOD_MANUFACTURER MOD_NAME MOD_SEATS MOD_CHO_MILEC-90A BeechcraftPA23-250 PiperPiper18-Feb-9815-Dec-0506-Nov-9323-Jun-9421-Apr-9015-JM-9629-Jan-9712-Mar-9518-Nov-9717-Apr-9512-Aug-9523-Sep-94KingAirAztecNavajo Chieftain20-Dec-9502-Apr-9610-Mar-9405-Nov-9021-Jun-0323-4-9615-Mar-9705-Feb-9612-May-9686102.671.932.35

Answered: Image /qna-images/answer/003edcb0-488f-41c3-be76-ec629edf17b4.jpg

Write a query that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance). Hint (use the AIRCRAFT table).

Write a query that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance). Hint (use the AIRCRAFT table).

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter8: Advanced Sql

Section: Chapter Questions

Problem 69C: Update the DETAILRENTAL table to set the values in DETAIL_RETURNDATE to include a time component....

See similar textbooks

Similar questions

List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Use an INTERSECT operator. table name is:ORDER_LINEORLN_ORDER_NUMBER ORLN_PART_NUMBER ORLN_NUMBER_ORDERED ORLN_QUOTED_PRICE tablename is ORDER_TABLE ORDR_ORDER_NUMBER ORDR_ORDER_DATE ORDR_CUSTOMER_NUMBER tablename is CUSTOMER CUST_NUMBERCUST_LAST CUST_FIRST CUST_STREET CUST_CITY CUST_STATE CUST_ZIP_CODE CUST_BALANCE CUST_CREDIT_LIMIT CUST_SALES_REP_NUM tablename is PART PART_NUMBER PART_DESCRIPTION UNITS_ON_HAND ITEM_CLASS WAREHOUSE UNIT_PRICE tablename is SALES_REP SLSR_PKSLSR_LAST SLSR_FIRST SLSR_STREET SLSR_CITY SLSR_STATE SLSR_ZIP_CODE SLSR_TOTAL_COMMISSION SLSR_COMMISSION_RATE SELECT ORDR_ORDER_NUMBER, ORDR_ORDER_DATEFROM ORDER_TABLEWHERE ORDR_ORDER_NUMBER IN (SELECT ORLN_ORDER_NUMBERFROM ORDER_LINEWHERE ORLN_PART_NUMBER IN (SELECT PART_NUMBERFROM PARTWHERE…
Some rows of a User table are shown below: User ucode name phone scode 7 Alex 847 - 3902 UX 8 Tony 203 - 3902 PX 9 Charles BD 11 Mary 877 - 3333 BD Which of the following queries retrieves the rows where there is no phone? a. SELECT * FROM User WHERE phone IS NULL b. SELECT * FROM User WHERE phone = “ ” c. SELECT * FROM User WHERE phone NOT IS NULL d. SELECT * FROM User WHERE phone > 0
Please see image for information SQL Code: https://gist.githubusercontent.com/GistMasterPro/89cad4b0f93db12893c238b40d1d1d94/raw/707e8a95b879a58e4eafe21672bae0e1358975eb/sqlcode.sql
Question: (MySQL Syntax) Write a single UPDATE statement to change the due date for all books borrowed on same day as the borrowing patron's sign-up. These due dates should be changed to exactly 30 days after patron sign-up. Here are the tables: CREATE TABLE book(isbn VARCHAR(100) PRIMARY KEY,title VARCHAR(100) NOT NULL,author VARCHAR(100) NOT NULL,pub_date DATE); CREATE TABLE patron(id INT PRIMARY KEY,first_name VARCHAR(100) NOT NULL,last_name VARCHAR(100) NOT NULL,sign_up DATE NOT NULL); CREATE TABLE borrow(patron INT NOT NULL,book VARCHAR(100) NOT NULL,check_out_date DATE NOT NULL,due_date DATE NOT NULL,PRIMARY KEY(patron, book, check_out_date),FOREIGN KEY (patron) REFERENCES patron(id),FOREIGN KEY (book) REFERENCES book(isbn)); CREATE TABLE late_notice(patron INT NOT NULL,book VARCHAR(100) NOT NULL,check_out_date DATE NOT NULL,notice_date DATE,FOREIGN KEY (patron, book, check_out_date) REFERENCES borrow(patron, book, check_out_date));
Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70 $400.00 29 GR56 Grant Cleaners 737 Allard Kingston TX 78084 512-555-1231 $215.00 $225.00 22…
IF POSSIBLE PLEASE TYPE OR WRITE ELIGIBLY illustrate the process of normalizing the data shown in this table to third normal form (3NF). officeNo officeAddress telNo mgrStaffNo name B001 8 Jefferson Way, Portland, ME 97201 503-555-3618 S1500 Tom Daniels B002 City Center Plaza, Seattle, WA 98122 206-555-6756 S0010 Mary Martinez B003 14 – 8th Avenue, New York, NY 10012 212-371-3000 S0145 Art Peters B004 16 – 14th Avenue, Seattle, WA 98128 206-555-3131 S2250 Sally Stern Primary key: officeNo Why the above table is not in 3NF? Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF). c) Identify the primary and foreign keys in your 3NF relations.
Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
Will report for incorrect querry
Some examples of SQL Server character data types include NVARCHAR, NVARCHAR, and NVARCHAR.
Textbook: Digital Systems Chapter 8 Question/Problem 44 I'm not sure if I'm running the correct Query for this problem. The question is: "Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)" I ran this query without any errors: CREATE TRIGGER trg_char_hours AFTER INSERT ON CHARTER FOR EACH ROW UPDATE AIRCRAFT SET AC_TTAF = AC_TTAF + NEW.CHAR_HOURS_FLOWN, AC_TTEL = AC_TTEL + NEW.CHAR_HOURS_FLOWN, AC_TTER = AC_TTER + NEW.CHAR_HOURS_FLOWN WHERE AIRCRAFT.AC_NUMBER = NEW.AC_NUMBER; But the answer is still incorrect because the last row doesn't have the expected values. I'm not sure why the test query would delete any row with a CHAR_TRIP ABOVE 10018. I attached a screen of the output I'm getting: I saw in another answer this:…
Textbook: Digital Systems Chapter 8 Question/Problem 44 I'm not sure if I'm running the correct Query for this problem. The question is: "Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)" I ran this query without any errors: CREATE TRIGGER trg_char_hours AFTER INSERT ON CHARTER FOR EACH ROW UPDATE AIRCRAFT SET AC_TTAF = AC_TTAF + NEW.CHAR_HOURS_FLOWN, AC_TTEL = AC_TTEL + NEW.CHAR_HOURS_FLOWN, AC_TTER = AC_TTER + NEW.CHAR_HOURS_FLOWN WHERE AIRCRAFT.AC_NUMBER = NEW.AC_NUMBER; But the answer is still incorrect because the last row doesn't have the expected values. I'm not sure why the test query would delete any row with a CHAR_TRIP ABOVE 10018. I attached a screen of the output I'm getting:
SQL Server works with all three types of character data: NVARCHAR, NVARCHAR, and NVARCHAR.