Find the name of each trip containing the word pond

Assignment Help Database Management System

Reference no: EM132081365

You just need the SQL statements for these questions:

1. 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 ID, customer number, and total price for all reservations where the number of persons is greater than four. Use the column name TOTAL_PRICE for the calculated field.

2. Find the name of each trip containing the word "Pond."

3. List the guide's last name and guide's first name for all guides that were hired before June 10, 2013.

4. What is the average distance and the average maximum group size for each type of trip?

5. Display the different seasons in which trips are offered. List each season only once.

6. List the reservation IDs for reservations that are for a paddling trip. (Hint: Use a subquery.)

7. What is the longest distance for a biking trip?

8. For each trip in the RESERVATION table that has more than one reservation, group by trip ID and sum the trip price. (Hint: Use the COUNT function and a HAVING clause.)

9. How many current reservations does Colonial Adventure Tours have and what is the total number of persons for all reservations?

10. List the reservation ID and trip ID for all trips that occur in the month of July, 2016. There are multiple ways to create this query.

Reference no: EM132081365

Questions Cloud

Write a program that takes a command line parameter : Write a program Maze.java that takes a command line parameter N, and generates a random N-by-N perfect maze.

Create a new project folder that will contain the helper : Create a new Project folder that will contain the 3 Helper classes: the PalindromeHelper, the ReversePoemHelper, and the AdoptAPetHelper.

Create an application which adds assignments : Which Adds, Edits, and Deletes assignments onto a storage medium, with grades per student-per assignment.

Compose a program that writes the coordinates of a random : Compose a program that writes the coordinates of a random point (a, b, c) on the surface of a sphere. To generate such a point, use Marsaglia's method.

Find the name of each trip containing the word pond : How many current reservations does Colonial Adventure Tours have and what is the total number of persons for all reservations?

Create a simple php form code with handling form : You need simple php form code with handling form. You need the following features in the form in the following order.

Write a python script that will accept an input file : You need a python script that will accept an input file and count the number of words in a paragraph in the file.

Initiate or set an armed intervention : What is the criteria adopted by the U.S. presidents to initiate or set an armed intervention?

Common stock and preferred stock : What are some differences between common stock and preferred stock?

User Account

All Pages