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
Explanation:!!
I hope you Feel better :)
Answer:
14.36((14MPa) approximately
Explanation:
In this question, we are asked to calculate the stress tightened in a bolt to a stress of 69MPa.
Please check attachment for complete solution and step by step explanation
Your options for navigating this roundabout would include driving in a counter-clockwise direction and then making your exit to the right lane.
<h3>What is a roundabout? </h3>
A roundabout is a circular intersection that make junctions or intersections of roads safer, because it is designed and developed to physically direct drivers and pedestrians to move in a counter-clockwise direction.
In this scenario, your options for navigating this roundabout as the driver of the red SUV would include driving in a counter-clockwise direction and then making your exit to the right lane.
Read more on roundabout here: brainly.com/question/22580476
#SPJ1
Hi! I believe the answer is 2 meters(: