Purchase Solution

Modifiy SQL statement for aircraft fuel

Not what you're looking for?

Ask Custom Question

See attachment

Modify the query in Problem 1 above to include the computed (derived) attribute "fuel per hour." (Hint: It is possible to use SQL to produce computed "attributes" that are not stored in any table. For example, the following SQL query is perfectly acceptable:
SELECT CHAR_DISTANCE, CHAR_FUEL_GALLONS/CHAR_DISTANCE
FROM CHARTER;
(The above query produces the "gallons per mile flown" value.) Use a similar technique on joined tables to produce the "gallons per hour" output shown in the figure below. (Note that 67.2 gallons/1.5 hours produces 44.8 gallons per hour.)

Attachments
Purchase this Solution

Solution Summary

Calculate gallons per hour

Solution Preview

SELECT c.CHAR_DATE, c.AC_NUMBER, m.MOD_NAME,
c.CHAR_HOURS_FLOWN, ...

Purchase this Solution


Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

C# variables and classes

This quiz contains questions about C# classes and variables.