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
A. 5 seconds :) Good luck!
That would be B, I hope this helps!
Friction losses in pipes can be reduced by decreasing the length of the pipes, reducing the surface roughness of the pipes, and increasing the pipe diameter. Thus, options (c),(e), and (f) hold correct answers.
Friction loss is a measure of the amount of energy a piping system loses because flowing fluids meet resistance. As fluids flow through the pipes, they carry energy with them. Unfortunately, whenever there is resistance to the flow rate, it diverts fluids, and energy escapes. These opposing forces result in friction loss in pipes.
Friction loss in pipes can decrease the efficiency of the functions of pipes. These are a few ways by which friction loss in pipes can be reduced and the efficiency of the piping system can be boosted:
- <u><em>Decrease the length of the pipes</em></u>: By decreasing pipe lengths and avoiding the use of sharp turns, fittings, and tees, whenever possible result in a more natural path for fluids to flow.
- <u><em>Reduce the surface roughness of the pipes</em></u>: By reducing the interior surface roughness of pipes, a smooth and clearer path is provided for liquids to flow.
- <u><em>Increase the pipe diameter: </em></u>By widening the diameters of pipes, it is ensured that fluids squeeze through pipes easily.
You can learn more about friction losses at
brainly.com/question/13348561
#SPJ4
