Colonial Adventure Tours calculates the total price of a trip by adding the trip price plus other fees and multiplying the result 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.

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:

answer:

science is the study of the nature and behavior of natural things and the knowledge that we obtain about them. a science is a particular branch of science such as physics, chemistry, or biology. physics is the best example of a science which has developed strong, abstract theories.

pseudoscience is a collection of beliefs or practices mistakenly regarded as being based on scientific method.

plz rate as brainliest

answer:

explanation:

sbbdbdbdbdbdndjd