1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
dusya [7]
3 years ago
9

Colonial Adventure Tours calculates the total price of a trip by adding the trip price plus other fees and multiplying the resul

t by the number of persons included in the reservation. List the reservation ID, trip name, customer’s last name, and total cost for all reservations where the number of persons is greater than four. Use the column name TotalCost for the calculated field.
Engineering
1 answer:
Vilka [71]3 years ago
3 0

Answer:

The following query is used to display TripName. Reservationld, FirstName. LastName and TotalCost of trip by adding the trip price plus other fees and multiplying the result by the number of persons which have number of persons >4.

Query:

SELECT ReservationlD, Trip.TripName. Customer.LastName. Customer.FirstName. (TripPrice+OtherFees) 'NumPersons as TotalCost FROM Reservation, Trip, Customer WHERE NumPersons>4 AND Reservation.TriplD=Trip.TriplD AND

Customer. CustomerNum=Reservation.CustomerNum:

Explanation:

  • Select clause is used to retrieve data from specified database table or relation and returns the data in the form of table.
  • ReservationID. Trip.TripName. Customer.LastName. Customer.FirstName are the column name of table.
  • (TripPrice+OtherFees) 'NumPersons will calculate the total cost of the Trip and stored it into TotalCost column.
  • As clause is used to give new name TotalCost to resultant column.
  • FROM clause specifies one or more table from where records to be retrieved. o Reservation. Trip and Customer are the table name.
  • WHERE clause is used in SQL query to retrieve only those records that satisfy the specified condition

You might be interested in
What careers could you potential do if you
Margarita [4]

Answer:

Engineering careers. If you want to stay in engineering, your job opportunities are very much linked to your degree type, and you probably know what many of them are already. ...

Consulting. ...

Technical writing. ...

Business. ...

Investment banking. ...

Law. ...

Manufacturing and production. ...

Logistics and supply chain.

Explanation:

3 0
2 years ago
Water is being added to a storage tank at the rate of 500 gal/min. Water also flows out of the bottom through a 2.0-in-inside di
melomori [17]

Answer:

From the answer, the water level is falling (since rate of outflow is more than that of inflow), and the rate at which the water level in the storage tank is falling is

(dh/dt) = - 0.000753

Units of m/s

Explanation:

Let the volume of the system at any time be V.

V = Ah

where A = Cross sectional Area of the storage tank, h = height of water level in the tank

Let the rate of flow of water into the tank be Fᵢ.

Take note that Fᵢ is given in the question as 500 gal/min = 0.0315 m³/s

Let the rate of flow of water out of the storage tank be simply F.

F is given in the form of (cross sectional area of outflow × velocity)

Cross sectional Area of outflow = πr²

r = 2 inches/2 = 1 inch = 0.0254 m

Cross sectional Area of outflow = πr² = π(0.0254)² = 0.00203 m²

velocity of outflow = 60 ft/s = 18.288 m/s

Rate of flow of water from the storage tank = 0.0203 × 18.288 = 0.0371 m³/s

We take an overall volumetric balance for the system

The rate of change of the system's volume = (Rate of flow of water into the storage tank) - (Rate of flow of water out of the storage tank)

(dV/dt) = Fᵢ - F

V = Ah (since A is constant)

dV/dt = (d/dt) (Ah) = A (dh/dt)

dV/dt = A (dh/dt) = Fᵢ - F

Divide through by A

dh/dt = (Fᵢ - F)/A

Fi = 0.0315 m³/s

F = 0.0371 m³/s

A = Cross sectional Area of the storage tank = πD²/4

D = 10 ft = 3.048 m

A = π(3.048)²/4 = 7.30 m²

(dh/dt) = (0.0315 - 0.0370)/7.3 = - 0.000753

(dh/dt) = - 0.000753

4 0
2 years ago
Outline the process used to test the following hypothesis: Titanium cages are stronger than steel cages for hockey goalie masks.
son4ous [18]

Answer:

true

Explanation:

8 0
3 years ago
A machine used to lift motorcycles consists of an electric winch pulling on one supporting cable of a block and tackle system. T
Kobotan [32]

Answer: So you are dealing with maximum and minimum weights and you want to know what MINIMUM number of supporting strands for this block and tackle system are needed I believe. If so you are dealing with economic imbalances Though we are not worrying about money Right? Right we need physics which Physics study matter and how it moves You would need 8 STRANDS

Explanation: Step By Step

5 0
3 years ago
(1.24) Consumer Reports is doing an article comparing refrigerators in their next issue. Some of the characteristics to be inclu
kondaur [170]

Answer:

“height is a quantitative variable ”

Explanation:

According to the question asked, answer is “height is a quantitative variable ”

Height is a quantitative variable because it is related to the measurement and in measurement, when we measure something we deal with number (numerical data)

Numerical data is a type of quantitative data that is why we say “height is a quantitative variable”  

There are some other possible questions in the given paragraph which I would like to mention here,  are as following:

Which are the categorical variables in the given report?

<u>Answer: </u>Energy star complaints

Top, Bottom or side-by-side freezer

Which are the quantitative variables in the given report?

<u>Answer:</u> Estimated Energy Consumption in kilowatts

Width, depth, and height in inches

Capacity in Cubic Feet  

What are the individuals in the report?

<u>Answer: </u>The brand name and model  

8 0
2 years ago
Other questions:
  • The net potential energy EN between two adjacent ions, is sometimes represented by the expression
    13·1 answer
  • All MOS devices are subject to damage from:________
    7·1 answer
  • Where the velocity is highest in the radial direction? Why?
    9·1 answer
  • Prompt the user to enter five numbers, being five people's weights. Store the numbers in an array of doubles. Output the array's
    11·1 answer
  • When moving cylinders always remove and make
    8·1 answer
  • A(n)_____ is a device that provides the power and motion to manipulate the moving parts of a valve or damper used to control flu
    9·1 answer
  • A thick steel slab ( 7800 kg/m3 , c 480 J/kg K, k 50 W/m K) is initially at 300 C and is cooled by water jets impinging on one o
    15·1 answer
  • An intelligence signal is amplified by a 65% efficient amplifier before being combined with a 250W carrier to generate an AM sig
    5·1 answer
  • Suppose you are asked to design an office building. Explain what type of drawing you would use and why.
    8·2 answers
  • For many people in 3D modeling copyrights and licensing allow them to earn a living.
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!