Question

SQL Homework

1. For each reservation, list the reservation ID, trip ID, customer number, and customer last name. Order the results by customer last name.

2. For each reservation for customer Ryan Goff, list the reservation ID, trip ID, and number of persons.

3. List the trip name of each trip that has Miles Abrams as a guide.

4. List the trip name of each trip that has the type Biking and that has Rita Boyers as a guide.

5. For each reservation that has a trip date of July 23, 2016, list the customer’s last name, the trip name, and the start location.

6. List the reservation ID, trip ID, and trip date for reservations for a trip in Maine (ME). Use the IN operator in your query.

7. Repeat Exercise 6, but this time use the EXISTS operator in your query.

8. Find the guide last name and guide first name of all guides who can lead a paddling trip. (Note: The query results should include duplicate values.)

9. Repeat Exercise 8 but use aliases for the table names.

10. List the trip IDs and trip names for each pair of trips that have the same start location. (For example, one such pair would be trip ID 2 and trip ID 3, because the start location of both trips is Weathersfield.) The first trip ID listed should be the major sort key, and the second trip ID should be the minor sort key.

11. Find the trip name of all reservations for hiking trips and sort the results by trip name in ascending order.

12. List the number and name of each customer that either lives in the state of New Jersey (NJ), or that currently has a reservation, or both.

13. List the number and name of each customer that lives in the state of New Jersey (NJ) and that currently has a reservation.

14. Find the trip ID and trip name for each trip whose maximum group size is greater than the maximum group size of every trip that has the type Hiking.

15. Find the trip ID and trip name for each trip whose maximum group size is greater than the maximum group size of at least one trip that has the type Biking.

16. Display the trip ID, trip name, and reservation ID for all trips. All trips should be included in the result. For those trips that currently do not have reservations, the reservation ID should be left blank. Order the results by trip ID.

Answer 1

PLEASE LIKE THE ANSWER

1. SELECT reservationID, tripID, customernumber, customerlastname FROM Reservation ORDER BY customerlastname;

2. SELECT  reservationID, tripID, NumOfpersons FROM Reservation WHERE customername= "Ryan Goff";

3. SELECT tripName FROM Trip WHERE guide="Miles Abrams";

4. SELECT tripName FROM Trip WHERE Type="Biking" AND  guide="Rita Boyers";

5. SELECT customerlastname, tripName, startlocation FROM reservation WHERE TripeDate="July 23, 2016";

6. SELECT reservationID, tripID, tripdate AS a, b, c FROM reservation WHERE (a IN Maine AND b IN Maine AND c IN Maine);

7. SELECT reservationID, tripID, tripdate FROM reservation WHERE EXISTS( SELECT reservationID, tripID, tripdate FROM Maine);

8. SELECT guidelastname, guidefirstname FROM Trip WHERE triptype="paddling trip";

AS PER CHEGG GUIDELINES WHEN STUDENT HAVE NOT MENTIONED HOW MANY QUESTION NEED TO BE ATTEMPTED WE HAVE TO ATTEMPT AT MAX 5 TO 6 QUESTIONS. DO LIKE THE ANSWER IF IT HELPS.

THANKYOU