9 HINT use a Join statement I had a query that would show me all of the trips reservations and all of the customers even if the customer did not make a reservation 1 0 HINT use a Join statement I had a query that showed me all of the trips and all of the guides Please submit an SQL statement as well as your answer to this question, which trip did not have a guide Please help, thank you text file below Create Schema Colonial Use Colonial CREATE TABLE GUIDE ( GUIDE NUM CHAR ( 4 ) PRIMARY KEY, LAST NAME CHAR ( 1 5 ) , FIRST NAME CHAR ( 1 5 ) , ADDRESS CHAR ( 2 5 ) , CITY CHAR ( 2 5 ) , STATE CHAR ( 2 ) , POSTAL CODE CHAR ( 5 ) , PHONE NUM CHAR ( 1 2 ) , HIRE DATE DATE ) CREATE TABLE CUSTOMER ( CUSTOMER NUM CHAR ( 4 ) PRIMARY KEY, LAST NAME CHAR ( 3 0 ) NOT NULL, FIRST NAME CHAR ( 3 0 ) , ADDRESS CHAR ( 3 5 ) , CITY CHAR ( 3 5 ) , STATE CHAR ( 2 ) , POSTAL CODE CHAR ( 5 ) , PHONE CHAR ( 1 2 ) ) CREATE TABLE RESERVATION ( RESERVATION ID CHAR ( 7 ) PRIMARY KEY, TRIP ID DECIMAL ( 3 , 0 ) , TRIP DATE DATE, NUM PERSONS DECIMAL ( 3 , 0 ) , TRIP PRICE DECIMAL ( 6 , 2 ) , OTHER FEES DECIMAL ( 6 , 2 ) , CUSTOMER NUM CHAR ( 4 ) ) CREATE TABLE TRIP ( TRIP ID DECIMAL ( 3 , 0 ) PRIMARY KEY, TRIP NAME CHAR ( 7 5 ) , START LOCATION CHAR ( 5 0 ) , STATE CHAR ( 2 ) , DISTANCE DECIMAL ( 4 , 0 ) , MAX GRP SIZE DECIMAL ( 4 , 0 ) , TYPE CHAR ( 2 0 ) , SEASON CHAR ( 2 0 ) ) CREATE TABLE TRIP GUIDES ( TRIP ID DECIMAL ( 3 , 0 ) , GUIDE NUM CHAR ( 4 ) , PRIMARY KEY ( TRIP ID , GUIDE NUM ) ) INSERT INTO GUIDE VALUES ( ' AM 0 1 ' , 'Abrams','Miles', ' 5 4 Quest Ave ' , 'Williamsburg', ' MA ' , ' 0 1 0 9 6 ' , ' 6 1 7 5 5 5 6 0 3 2 ' , ' 2 0 1 2 6 3 ' ) INSERT INTO GUIDE VALUES ( ' BR 0 1 ' , 'Boyers','Rita', ' 1 4 0 Oakton Rd ' , 'Jaffrey', ' NH ' , ' 0 3 4 5 2 ' , ' 6 0 3 5 5 5 2 1 3 4 ' , ' 2 0 1 2 3 4 ' ) INSERT INTO GUIDE VALUES ( ' DH 0 1 ' , 'Devon','Harley', ' 2 5 Old Ranch Rd ' , 'Sunderland', ' MA ' , ' 0 1 3 7 5 ' , ' 7 8 1 5 5 5 7 7 6 7 ' , ' 2 0 1 2 1 8 ' ) INSERT INTO GUIDE VALUES ( ' GZ 0 1 ' , 'Gregory','Zach', ' 7 Moose Head Rd ' , 'Dummer', ' NH ' , ' 0 3 5 8 8 ' , ' 6 0 3 5 5 5 8 7 6 5 ' , ' 2 0 1 2 1 1 4 ' ) INSERT INTO GUIDE VALUES ( ' KS 0 1 ' , 'Kiley','Susan', ' 9 4 3 Oakton Rd ' , 'Jaffrey', ' NH ' , ' 0 3 4 5 2 ' , ' 6 0 3 5 5 5 1 2 3 0 ' , ' 2 0 1 3 4 8 ' ) INSERT INTO GUIDE VALUES ( ' KS 0 2 ' , 'Kelly','Sam', ' 9 Congaree Ave ' , 'Fraconia', ' NH ' , ' 0 3 5 8 0 ' , ' 6 0 3 5 5 5 0 0 0 3 ' , ' 2 0 1 3 6 1 0 ' ) INSERT INTO GUIDE VALUES ( ' MR 0 1 ' , 'Marston','Ray', ' 2 4 Shenandoah Rd ' , 'Springfield', ' MA ' , ' 0 1 1 0 1 ' , ' 7 8 1 5 5 5 2 3 2 3 ' , ' 2 0 1 5 9 1 4 ' ) INSERT INTO GUIDE VALUES ( ' RH 0 1 ' , 'Rowan','Hal', ' 1 2 Heather Rd ' , 'Mount Desert', ' ME ' , ' 0 4 6 6 0 ' , ' 2 0 7 5 5 5 9 0 0 9 ' , ' 2 0 1 5 6 2 ' ) INSERT INTO GUIDE VALUES ( ' SL 0 1 ' , 'Stevens','Lori', ' 1 5 Riverton Rd ' , 'Coventry', ' VT ' , ' 0 5 8 2 5 ' , ' 8 0 2 5 5 5 3 3 3 9 ' , ' 2 0 1 4 9 5 ' ) INSERT INTO GUIDE VALUES ( ' UG 0 1 ' , 'Unser','Glory', ' 3 4 2 Pineview St ' , 'Danbury', ' CT ' , ' 0 6 8 1 0 ' , ' 2 0 3 5 5 5 8 5 3 4 ' , ' 2 0 1 5 2 2 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 0 1 ' , 'Northfold','Liam', ' 9 Old Mill Rd ' , 'Londonderry', ' NH ' , ' 0 3 0 5 3 ' , ' 6 0 3 5 5 5 7 5 6 3 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 0 2 ' , 'Ocean','Arnold', ' 2 3 3 2 South St Apt 3 ' , 'Springfield', ' MA ' , ' 0 1 1 0 1 ' , ' 4 1 3 5 5 5 3 2 1 2 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 0 3 ' , 'Kasuma','Sujata', ' 1 3 2 Main St 1 ' , 'East Hartford', ' CT ' , ' 0 6 1 0 8 ' , ' 8 6 0 5 5 5 0 7 0 3 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 0 4 ' , 'Goff','Ryan', ' 1 6 4 A South Bend Rd ' , 'Lowell', ' MA ' , ' 0 1 8 5 4 ' , ' 7 8 1 5 5 5 8 4 2 3 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 0 5 ' , 'McLean','Kyle', ' 3 4 5 Lower Ave ' , 'Wolcott', ' NY ' , ' 1 4 5 9 0 ' , ' 5 8 5 5 5 5 5 3 2 1 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 0 6 ' , 'Morontoia','Joseph', ' 1 5 6 Scholar St ' , 'Johnston', ' RI ' , ' 0 2 9 1 9 ' , ' 4 0 1 5 5 5 4 8 4 8 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 0 7 ' , 'Marchand','Quinn', ' 7 6 Cross Rd ' , 'Bath', ' NH ' , ' 0 3 7 4 0 ' , ' 6 0 3 5 5 5 0 4 5 6 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 0 8 ' , 'Rulf','Uschi', ' 3 2 Sheep Stop St ' , 'Edinboro', ' PA ' , ' 1 6 4 1 2 ' , ' 8 1 4 5 5 5 5 5 2 1 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 0 9 ' , 'Caron','Jean Luc', ' 1 0 Greenfield St ' , 'Rome', ' ME ' , ' 0 4 9 6 3 ' , ' 2 0 7 5 5 5 9 6 4 3 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 1 0 ' , 'Bers','Martha', ' 6 5 Granite St ' , 'York', ' NY ' , ' 1 4 5 9 2 ' , ' 5 8 5 5 5 5 0 1 1 1 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 1 2 ' , 'Jones','Laura', ' 3 7 3 Highland Ave ' , 'Somerville', ' MA ' , ' 0 2 1 4 3 ' , ' 8 5 7 5 5 5 6 2 5 8 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 1 5 ' , 'Vaccari','Adam', ' 1 2 8 2 Ocean Walk','Ocean CITY', ' NJ ' , ' 0 8 2 2 6 ' , ' 6 0 9 5 5 5 5 2 3 1 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 1 6 ' , 'Murakami','Iris', ' 7 Cherry Blossom St ' , 'Weymouth', ' MA ' , ' 0 2 1 8 8 ' , ' 6 1 7 5 5 5 6 6 6 5 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 1 9 ' , 'Chau','Clement', ' 1 8 Ark Ledge Ln ' , 'Londonderry', ' VT ' , ' 0 5 1 4 8 ' , ' 8 0 2 5 5 5 3 0 9 6 ' ) INSERT INTO CUSTOMER VALUES ( ' 1 2 0 ' , 'Gernowski','Sadie', ' 2 4 Stump Rd

The Answer is in the image, click to view ...

Question: 9 . HINT use a Join statement. I had a query that would show me all of the trips reservations and all of the customers

9 .

HINT use a Join statement. I had a query that would show me all of the trips reservations and all of the customers even if the customer did not make a reservation.

10 .

HINT use a Join statement. I had a query that showed me all of the trips and all of the guides. Please submit an SQL statement as well as your answer to this question, which trip did not have a guide?

Please help, thank you!

text file below:

Create Schema Colonial;

Use Colonial;

CREATE TABLE GUIDE

(

GUIDE

_

NUM CHAR

(4)

PRIMARY KEY,

LAST

_

NAME CHAR

(15),

FIRST

_

NAME CHAR

(15),

ADDRESS CHAR

(25),

CITY CHAR

(25),

STATE CHAR

(2),

POSTAL

_

CODE CHAR

(5),

PHONE

_

NUM CHAR

(12),

HIRE

_

DATE DATE

)

;

CREATE TABLE CUSTOMER

(

CUSTOMER

_

NUM CHAR

(4)

PRIMARY KEY,

LAST

_

NAME CHAR

(30)

NOT NULL,

FIRST

_

NAME CHAR

(30),

ADDRESS CHAR

(35),

CITY CHAR

(35),

STATE CHAR

(2),

POSTAL

_

CODE CHAR

(5),

PHONE CHAR

(12))

;

CREATE TABLE RESERVATION

(

RESERVATION

_

ID CHAR

(7)

PRIMARY KEY,

TRIP

_

ID DECIMAL

(3, 0),

TRIP

_

DATE DATE,

NUM

_

PERSONS DECIMAL

(3, 0),

TRIP

_

PRICE DECIMAL

(6, 2),

OTHER

_

FEES DECIMAL

(6, 2),

CUSTOMER

_

NUM CHAR

(4))

;

CREATE TABLE TRIP

(

TRIP

_

ID DECIMAL

(3, 0)

PRIMARY KEY,

TRIP

_

NAME CHAR

(75),

START

_

LOCATION CHAR

(50),

STATE CHAR

(2),

DISTANCE DECIMAL

(4, 0),

MAX

_

GRP

_

SIZE DECIMAL

(4, 0),

TYPE CHAR

(20),

SEASON CHAR

(20))

;

CREATE TABLE TRIP

_

GUIDES

(

TRIP

_

ID DECIMAL

(3, 0),

GUIDE

_

NUM CHAR

(4),

PRIMARY KEY

(

TRIP

_

,

GUIDE

_

NUM

))

;

INSERT INTO GUIDE

VALUES

('

01',

'Abrams','Miles',

' 54

Quest Ave.

',

'Williamsburg',

'

',' 01096',' 617 - 555 - 6032',' 2012 - 6 - 3')

;

INSERT INTO GUIDE

VALUES

('

01',

'Boyers','Rita',

' 140

Oakton Rd

.',

'Jaffrey',

'

',' 03452',' 603 - 555 - 2134',' 2012 - 3 - 4')

;

INSERT INTO GUIDE

VALUES

('

01',

'Devon','Harley',

' 25

Old Ranch Rd

.',

'Sunderland',

'

',' 01375',' 781 - 555 - 7767',' 2012 - 1 - 8')

;

INSERT INTO GUIDE

VALUES

('

01',

'Gregory','Zach',

' 7

Moose Head Rd

.',

'Dummer',

'

',' 03588',' 603 - 555 - 8765',' 2012 - 11 - 4')

;

INSERT INTO GUIDE

VALUES

('

01',

'Kiley','Susan',

' 943

Oakton Rd

.',

'Jaffrey',

'

',' 03452',' 603 - 555 - 1230',' 2013 - 4 - 8')

;

INSERT INTO GUIDE

VALUES

('

02',

'Kelly','Sam',

' 9

Congaree Ave.

',

'Fraconia',

'

',' 03580',' 603 - 555 - 0003',' 2013 - 6 - 10')

;

INSERT INTO GUIDE

VALUES

('

01',

'Marston','Ray',

' 24

Shenandoah Rd

.',

'Springfield',

'

',' 01101',' 781 - 555 - 2323',' 2015 - 9 - 14')

;

INSERT INTO GUIDE

VALUES

('

01',

'Rowan','Hal',

' 12

Heather Rd

.',

'Mount Desert',

'

',' 04660',' 207 - 555 - 9009',' 2015 - 6 - 2')

;

INSERT INTO GUIDE

VALUES

('

01',

'Stevens','Lori',

' 15

Riverton Rd

.',

'Coventry',

'

',' 05825',' 802 - 555 - 3339',' 2014 - 9 - 5')

;

INSERT INTO GUIDE

VALUES

('

01',

'Unser','Glory',

' 342

Pineview St

.',

'Danbury',

'

',' 06810',' 203 - 555 - 8534',' 2015 - 2 - 2')

;

INSERT INTO CUSTOMER

VALUES

(' 101',

'Northfold','Liam',

' 9

Old Mill Rd

.',

'Londonderry',

'

',' 03053',' 603 - 555 - 7563')

;

INSERT INTO CUSTOMER

VALUES

(' 102',

'Ocean','Arnold',

' 2332

South St

.

Apt

3',

'Springfield',

'

',' 01101',' 413 - 555 - 3212')

;

INSERT INTO CUSTOMER

VALUES

(' 103',

'Kasuma','Sujata',

' 132

Main St

.

1',

'East Hartford',

'

',' 06108',' 860 - 555 - 0703')

;

INSERT INTO CUSTOMER

VALUES

(' 104',

'Goff','Ryan',

' 164

A South Bend Rd

.',

'Lowell',

'

',' 01854',' 781 - 555 - 8423')

;

INSERT INTO CUSTOMER

VALUES

(' 105',

'McLean','Kyle',

' 345

Lower Ave.

',

'Wolcott',

'

',' 14590',' 585 - 555 - 5321')

;

INSERT INTO CUSTOMER

VALUES

(' 106',

'Morontoia','Joseph',

' 156

Scholar St

.',

'Johnston',

'

',' 02919',' 401 - 555 - 4848')

;

INSERT INTO CUSTOMER

VALUES

(' 107',

'Marchand','Quinn',

' 76

Cross Rd

.',

'Bath',

'

',' 03740',' 603 - 555 - 0456')

;

INSERT INTO CUSTOMER

VALUES

(' 108',

'Rulf','Uschi',

' 32

Sheep Stop St

.',

'Edinboro',

'

',' 16412',' 814 - 555 - 5521')

;

INSERT INTO CUSTOMER

VALUES

(' 109',

'Caron','Jean Luc',

' 10

Greenfield St

.',

'Rome',

'

',' 04963',' 207 - 555 - 9643')

;

INSERT INTO CUSTOMER

VALUES

(' 110',

'Bers','Martha',

' 65

Granite St

.',

'York',

'

',' 14592',' 585 - 555 - 0111')

;

INSERT INTO CUSTOMER

VALUES

(' 112',

'Jones','Laura',

' 373

Highland Ave.

',

'Somerville',

'

',' 02143',' 857 - 555 - 6258')

;

INSERT INTO CUSTOMER

VALUES

(' 115',

'Vaccari','Adam',

' 1282

Ocean Walk','Ocean CITY',

'

',' 08226',' 609 - 555 - 5231')

;

INSERT INTO CUSTOMER

VALUES

(' 116',

'Murakami','Iris',

' 7

Cherry Blossom St

.',

'Weymouth',

'

',' 02188',' 617 - 555 - 6665')

;

INSERT INTO CUSTOMER

VALUES

(' 119',

'Chau','Clement',

' 18

Ark Ledge Ln

.',

'Londonderry',

'

',' 05148',' 802 - 555 - 3096')

;

INSERT INTO CUSTOMER

VALUES

(' 120',

'Gernowski','Sadie',

' 24

Stump Rd

.<Step by Step Solution There are 3 Steps involved in it 1 Expert Approved Answer Step: 1 Unlock Question Has Been Solved by an Expert! Get step-by-step solutions from verified subject matter experts View Solution Step: 2 Unlock Step: 3 UnlockStudents Have Also Explored These Related Databases Questions! Q: 9 . HINT use a Join statement. I had a query that would show me all of the trips reservations and all of the customers even if the customer did not make a reservation. 1 0 . HINT use a Join... Q: I am working on multi-table queries for my SQL class using a premade database. I am very unsure which operator to use to join tables based on the questions parameters. 1. List all current... Q: create database AutoRentals go use AutoRentals go create table Customer (CID integer, CName varchar(20), Age integer, Resid_City varchar(20), BirthPlace varchar(20), Constraint PK_Customer Primary... Q: 1 : ( 1 0 Points ) Use the customers' table, and write a query statement to show CustomerName, state, and country columns. 2 : ( 1 0 Points ) Use the employees table, and write a query statement to... Q: create database AutoRentals go use AutoRentals go create table Customer (CID integer, CName varchar(20), Age integer, Resid_City varchar(20), BirthPlace varchar(20), Constraint PK_Customer Primary... Q: -- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders... Q: Step 1 From the Windows start menu click on SQL Server Management Studio. Step 2 Login to the database server. On campus enter the following: For server type select Database Engine (which should be... Q: PROJECT STEPS 1. Personal Insurance, Inc. is a national company that insures homeowners and renters. As a regional manager, you need to be able to use the extended management capabilities available... Q: 1 . Personal Insurance, Inc. is a national company that insures homeowners and renters. As a regional manager, you need to be able to use the extended management capabilities available through SQL .... Q: Requirements 1. Using the database structure created you created in Module 03, use the MySQL CLI to issue SQL INSERT statements to populate the tables. All tables are to have at least 10 records... Q: The length of an injection-molded plastic case that holds magnetic tape is normally distributed with a length of 90.2 millimeters and a standard deviation of 0.1 millimeter. (a) What is the... Q: A heat engine with a thermal efficiency of 25% is used to hoist 2.5-kg bricks to an elevation of 3.0 m. If the engine expels heat to the environment at a rate of 1.2 x 106 J/h, how many bricks can... Q: The current 3 - month spot interest rate is equal to 4 . 0 0 % . The current 6 - month spot interest rate is equal to 4 . 2 5 % . What is the non - arbitrage the 3 X 6 FRA interest rate? Q: P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20... Q: Teamwork. As directed by your instructor, meet in a small group to discuss the following questions. (Objective 2) a. How do you feel when a teacher, manager, colleague, or service representative... Q: Technology. During the next conversation you have with a coworker, a family member, or someone not from this class, use paraphrasing at least once. E-mail your instructor to describe the effect... Q: Discuss five ways nonverbal messages could be presented in a positive manner when interviewing for a supervisory position in a business organization. Previous Question Next QuestionRecommended Textbook More Books Graph Database Modeling With Neo4j Authors: Ajit Singh 2nd Edition B0BDWT2XLR, 979-8351798783 Ask a Question and Get Instant Help! Get AnswerStudy Help Open in AppServices Sitemap Fun Definitions Become Tutor Used Textbooks Study Help Categories Recent Questions Expert Questions Campus Wear Sell Your Books Company Info Security Copyrights Privacy Policy Terms & Conditions SolutionInn Fee Scholarship Online Quiz Give Feedback, Get Rewards Get In Touch About Us Contact Us Career Jobs FAQ Student Discount Campus Ambassador Secure Payment Download Our App © 2026 SolutionInn. All Rights Reservedwindow.addEventListener("load",function(){jQuery(document).ready(function(t){

        // Clarity tracking
        (function(c,l,a,r,i,t,y){
            c[a]=c[a]||function(){(c[a].q=c[a].q||[]).push(arguments)};
            t=l.createElement(r);t.async=1;t.src="https://www.clarity.ms/tag/"+i;
            y=l.getElementsByTagName(r)[0];y.parentNode.insertBefore(t,y);
        })(window, document, "clarity", "script", "sjv6tuxsok");

        // Helper to read a cookie by name
        function getCookie(name) {
            return document.cookie
                .split('; ')
                .map(v => v.split('='))
                .reduce((acc, [k, val]) => (k === name ? decodeURIComponent(val || '') : acc), '');
        }

                 // Read cookies
         var si  = getCookie('si_u_id');
         var uid = getCookie('u_id');
         var zen = getCookie('zenid');
         // Send to Clarity
         if (si)  clarity('set', 'si_u_id', si);
         if (uid) clarity('set', 'u_id', uid);
         if (zen) clarity('set', 'zenid', zen);
         clarity('set', 'ip_address', '216.73.216.134');

        t.ajax({type:"POST",url:"/",data:{trackUserActivity:!0,reqUri:document.URL,referer:document.referrer},success:function(t){}})})},!1),window.addEventListener("load",function(){jQuery(document).ready(function(t){t.ajax({type:"POST",url:"/",data:{insertCrawler:!0,reqUri:document.URL,parseTime:"0.056",queryTime:"0.01654768548584",queryCount:"30"},success:function(t){}})})},!1),window.addEventListener("load",function(){jQuery(document).ready(function(){function t(t="",n=!1){var i="itms-apps://itunes.apple.com/app/id6462455425",e="openApp://action?"+t;isAndroid()?(setTimeout(function(){return window.location="market://details?id=com.solutioninn.studyhelp",!1},25),window.location=e):isIOS()?(setTimeout(function(){return window.location=i,!1},25),window.location=e):(i="https://apps.apple.com/in/app/id6462455425",n&&(i="https://play.google.com/store/apps/details?id=com.solutioninn.studyhelp"),window.open("about:blank","_blank").location.href=i)}jQuery("#appModal").modal("show"),jQuery(".download-app-btn").click(function(){t(jQuery(this).attr("data-question-open-url"))}),jQuery(".redirection").click(function(){var n=jQuery(this).attr("data-question-open-url"),i=jQuery(this).attr("data-id");void 0!=n?1==i?t(n,!0):t(n,!1):1==i?t("",!0):t("",!1)}),jQuery(".app-notification-close").click(function(){jQuery(".app-notification-section").css("visibility","hidden");var t=new FormData;t.append("hide_notification",!0),jQuery.ajax({type:"POST",url:"/",data:t,cache:!1,contentType:!1,processData:!1,beforeSend:function(){},success:function(t){location.reload()}})})})},!1);