SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 6 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 06 Jan 2018 My Price 10.00

CSIS 3722 Developing of Databases homework use

Need help with creating SQL queries for these questions here.

 

Homework 4 – Multi Table Queries

CSIS 3722 Developing of Databases

 

For this homework use the Colonial Adventure Tours database. Copy-Paste the SQL queries and the results below each exercise.

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

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

3.      Find the guide last name and guide first name of all guides who can lead a paddling trip.

(Note: The query results should include the duplicate values.)

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

5.      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.

6.      Repeat question 3 but list the guide name only once and sort the guide names in order by last name.

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 06 Jan 2018 09:01 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)