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]
4 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]4 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
Define Mechanism and mechanics.​
aivan3 [116]

mechanism, in mechanical construction, the means employed to transmit and modify motion in a machine or any assemblage of mechanical parts.

6 0
3 years ago
Read 2 more answers
In a creep test, increasing the temperature will (choose the best answer) A. increase the instantaneous initial deformation B. i
Hitman42 [59]

Answer:

All of the above

Explanation:

firstly, a creep can be explained as the gradual deformation of a material over a time period. This occurs at a fixed load with the temperature the same or more than the recrystallization temperature.

Once the material gets loaded, the instantaneous creep would start off and it is close to electric strain. in the primary creep area, the rate of the strain falls as the material hardens. in the secondary area, a balance between the hardening and recrystallization occurs. The material would get to be fractured hen recrstallization happens.  As temperature is raised the recrystallization gets to be more.

8 0
2 years ago
The heat transfer coefficient decreases with increasing x for both the laminar and turbulent regions a. True b. False
REY [17]

Answer:

A) True  

Explanation:

Yes this is true when length is creases the heat transfer coefficient decease with length.

The heat transfer(h) coefficient is varying with x by given expression

For Laminar flow

h \alpha \dfrac{1}{x^{\frac{1}{2}}}

For turbulent flow

h \alpha \dfrac{1}{x^{\frac{1}{5}}}

But when flow is in transitional state the heat heat transfer(h) coefficient is increases with x.But for laminar as well as turbulent flow h is decrease when x increases.

3 0
3 years ago
RKI Instruments borrowed $4,800,000 from a private equity firm for expansion of its facility for manufacturing carbon monoxide m
Tju [1.3M]

Answer:

n

Explanation:

6 0
3 years ago
For every 3 packages that Marcella wraps she uses 1/2 of a roll of wrapping paper if she uses 2 1/2 rolls of wrapping paper how
hram777 [196]
She wrapped 5 packages
6 0
3 years ago
Read 2 more answers
Other questions:
  • The Fibonacci sequence 1, 1, 2, 3, 5, 8, 13, 21…… starts with two 1s, and each term afterward is the sum of its two predecessors
    8·2 answers
  • WHEN WAS THE FIRST CAR INVENTED?
    13·2 answers
  • What is 1000 kJ/sec in watts?
    10·1 answer
  • A heavy ball with a weight of 110 N is hung from the ceiling of a lecture hall on a 4.9-m-long rope. The ball is pulled to one s
    6·1 answer
  • Using phasors, the value of 37 sin 50t + 30 cos(50t – 45°) is _________ cos(50t+(_____°)). Please report your answer so the magn
    5·1 answer
  • List two common units of measurement to describe height
    5·2 answers
  • Water at 310 K and a flow rate of 4 kg/s enters an alumina tube (k=177Wm K1) with an inner diameter of 0.20 m and a wall thickne
    13·1 answer
  • 11. Which of the following is the brake fluid most often used?
    11·2 answers
  • A driver complains that his front tires are wearing
    14·1 answer
  • When starting up a dual fuel system, the temperature rise method for determining airflow cannot be used with the compressor cycl
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!