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
How much will it cost to train the entire company to use a recycling program if the training includes paper handouts? (Remember,
bezimeni [28]

Answer:

With the current budget of $1,000, it is possible to train the company and buy 3 recycling carts given that recycling pickup within the area is free

Explanation:

The office waste management budget that is not being spent = $1,000

The given expense parameters are;

The training cost per hour per employee = $12.00

The number of people in the entire company = 45

The cost of preparing the training material per hour = $20.00

The number of people to create the training material = 3 people

The time it will take each person in creating the training material = 3 hours

The cost of recycling cart = $80.00 per cart

The cost of paper handouts per employee = $0.05

The cost of materials include;

The total cost for the training = $12.00 × 45 = $540

The cost for the handout = $0.05 × 45 = $2.25

The cost of preparing the materials = $20.00 × 3 × 3 = $180.00

The total costs of the training = $540 + $4 + $180.00 = $724

The amount available to buy cart = $1,000 - $724 = $276

Therefore;

The amount available to buy cart = $276

The number of carts that can be bought = 276/80 = 3.45 carts

Therefore, we round down to get;

The number of carts that can be bought = 3 carts

8 0
3 years ago
find magnitude of the resultant force, if 30N,40N,50N and 60N forces are acting along the line joining the centr of a square to
viktelen [127]

Answer:

56 feet

Explanation:

c 20 n north

7 0
3 years ago
Engineers need to look for non-technological systems, as well as technological problems, to solve problems. true or false
Anit [1.1K]
True


explanation: just makes sense
4 0
3 years ago
How to make a police car ​
S_A_V [24]

search it and you will get on internet

3 0
3 years ago
The absolute pressure in water at a depth of 9 m is read to be 185 kPa. Determine: a. The local atmospheric pressure b. The abso
ser-zykov [4K]

Answer:

a)Patm=135.95Kpa

b)Pabs=175.91Kpa

Explanation:

the absolute pressure is the sum of the water pressure plus the atmospheric pressure, which means that for point a we have the following equation

Pabs=Pw+Patm(1)

Where

Pabs=absolute pressure

Pw=Water pressure

Patm= atmospheric pressure

Water pressure is calculated with the following equation

Pw=γ.h(2)

where

γ=especific weight of water=9.81KN/M^3

H=depht

A)

Solving using ecuations 1 y 2

Patm=Pabs-Pw

Patm=185-9.81*5=135.95Kpa

B)

Solving using ecuations 1 y 2, and atmospheric pressure

Pabs=0.8x5x9.81+135.95=175.91Kpa

8 0
4 years ago
Other questions:
  • A stream of vinyl chloride monomer (VCM, H2C=CHCl, molecular weight = 62.5lb/lb-mol) in air is being produced from a process to
    7·1 answer
  • A particular NMOS device has parameters VT N = 0.6 V, L = 0.8µm, tox = 200 Å, and µn = 600 cm2 /V–s. A drain current of ID = 1.2
    14·1 answer
  • You are asked by your college crew to estimate the skin friction drag in their eight-seat racing shell. The hull of the shell ma
    5·1 answer
  • Define ""acidity"" of an aqueous solution. How do you compare the strength of acidity of solutions ?
    6·1 answer
  • Two synchronous motors having subtransient reactances of 0.8 and 0.25 p.u., respectively, on a base of 500 V 2 MVA are connected
    13·1 answer
  • Learning Goal: To use fundamental geometric and statics methods to determine the state of plane stress at the point on an elemen
    8·1 answer
  • 4. From two permeability tests it is found that the void ratio and hydraulic conductivity of a normally consolidated clay are 1.
    15·1 answer
  • Problem 3. The uniform beam is supported by two rods AB and CD that have cross-sectional areas of 10 mm2 and 15mm2, respectively
    12·1 answer
  • Estimate the maximum expected thermal conductivity for a Cermet that contains 58 vol% titanium carbide (TiC) particles in a coba
    8·1 answer
  • What should be given to a customer before doing a repair?
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!