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]
3 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]3 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
The product life cycle defines the stages that new products move through as they enter, are established in, and ultimately leave
Bas_tet [7]

Answer:

The four marketing mix of every new business are:

1. Product

2. Place

3. Price

4. Promotion

For each of the stages of product life cycle, those 4p should be use appropriately.

Explanation:

The four marketing mix of every new business are:

1. Product

2. Place

3. Price

4. Promotion

the product life cycle are directly proportional to the 4p of marketing. the product life cycle stages are introduction, growth, maturity and decline.

For each of the stages of product life cycle, those 4p should be use appropriately.

Stages of product life cycle and how the 4p fit into it.

The introduction stage:

at this stage, a new product just want to be introduced to the consumers. the product stage has being developed. The place where the product will fit in will also be consider. the location of people who consume this product. Pricing strategy consider a low price at the introduction stage, the business owner may not get any profit at this stage. then, continuous advertisement to create awareness of the product to the environment.

The growth stage:

the product will continuing to be move to different locations. the standard of the product quality will be maintained. the Pricing will start increasing. then, continuous advertisement to create awareness of the product and working on improving the product to suit the consumer.

the Mature stage:

At this stage, the consumer are fully aware of the product. wide range of location are reach. the pricing has reach its peak. Profit have been maximized. And, competitors of the product are in the market. Corporate social responsibility (CSR) will be the promotional value at this stage.

The Declining stage:

The business product have fully grown to its peak, and its only constant promotional values like CSR, advertisement, bonuses, can sustain it in the market. At this stage also, price comparison with other competitor should be carefully look into.

4 0
3 years ago
Nanotechnology is a scientific area that deals with making or changing things that are incredibly _______________. *
Dafna1 [17]
B tiny nano means small!!
3 0
3 years ago
Read 2 more answers
I m from India<br><br><br>5603642259 pd 123456 ​
Volgvan

Answer:

Hi there...

Explanation:

Please give me brainliest :)

6 0
3 years ago
Read 2 more answers
Join this game!! More than 20 points if you join
mote1985 [20]
I just deleted among us :/
6 0
3 years ago
Read 2 more answers
At a ski resort, water at 40 °F is pumped through a 3-in.-diameter, 2001-ft-long steel pipe from a pond at an elevation of 4286
deff fn [24]

Answer:

P = 24.38 hp

Explanation:

Given data:

diameter of steel pipe = 3 inc

length of pipe = 2001 ft

elevation of pond = 4286 ft

elevation of snow making machine = 4620 ft

Rate of water = 0.26 ft^3/s

Applying bernouli equation on bioth side

\frac{P}{\rho} + \frac{v_1^2}{2g} + z_1 + h_p =\frac{P_2}{\rho} + \frac{v_2^2}{2g} + z_2 + \frac{flv^2}{2gD}.....1

where P_2 = 182 psi

P_1 = 0, v_1 = 0

V =V_2 = \frac{Q}{\frac{\pi}{4} D^2}= \frac{0.26}{\frac{\pi}{4} \times (3/12)^2} = 5.30 ft/s

calculation fro friction factor

from standard table we have

\frac{\epsilon}{D} = \frac{0.00015}{(3/12)} = 6\times 10^{-4}

Re =\frac{VD}[\nu} = \frac{5.30 \times (3/12)}{1.66 \times 10^{-5}} = 7.96 \times 10^4

so for calculated R and\frac{\epsilon}{D}, F value = 0.0212

from equation 1

h_p = \frac{P_2}{\rho} + Z_2 -Z_1 +(1 + f\frac{l}{D}) \frac{V^2}{2g}

h_p = \frac{182 \times 144/ lb /ft^2}{62.4} + 4620 - 4286 + (1 + 0.0212 \frac{2001}{(3/12)}) \frac{5.30}{2\times 32.2}

h_p = 826.76ft so that

P =  \rho Q h_p = 62.4 \times 0.26 \times 826.76 = 13413.38 ft lb/s = 24.38 hp

3 0
3 years ago
Other questions:
  • The 1000-lb elevator is hoisted by the pulley system and motor M. The motor exerts a constant force of 500 lb on the cable. The
    9·1 answer
  • Interlocking stacked material is done by​ _____.
    10·2 answers
  • A home electrical system is joined to the electric company's system at the junction of the
    11·1 answer
  • For a very rough pipe wall the friction factor is constant at high Reynolds numbers. For a length L1 the pressure drop over the
    9·1 answer
  • How much memory can a 32 -bit processor support ?
    13·1 answer
  • Why do we need technical sketching?
    5·2 answers
  • Please help!!!! WHICH 2 SKILLS N ABILITIES R ESSENTIAL FOR A SHIP CAPTAIN?? A. Good vision B. Public speaking skills C. Leadersh
    15·2 answers
  • Using the tables for water, determine the specified property data at the indicated states. In each case, locate the state on ske
    10·1 answer
  • Brainliest need help
    15·1 answer
  • Outline how effective brainstorming should be set up so that it does not go off-track or alienate anyone.
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!