Using the DiveShop database, create a query that returns the following table exactly as shown. You may use any resources

[answerhappygod]

Using The Diveshop Database Create A Query That Returns The Following Table Exactly As Shown You May Use Any Resources 1 (115.55 KiB) Viewed 31 times

Using the DiveShop database, create a query that returns the following table exactly as shown. You may use any resources you wish, but you must complete the work on your own. Name Phone Number Sven Schiro (415) 555-8290 Michael Leblanc (213) 555-4390 Marcus Selby (601) 555-8645 Lowell Lutz (214) 555-2722 Ken Soule (303) 555-6695 David Burgett (206) 555-7580 Bruce Fowler (213) 555-7270 Amanda Gentry (301) 555-3172 Destination Name Monterey Fiji Great Barrier Reef Florida Santa Barbara Fiji Florida Santa Barbara Number of People 12 4 10 4 6 4 5 Cost Per Night Life Person 2000 Wild 5000 Sleepy 20000 Pleasant 6000 Pleasant 6000 Wild 5000 Sleepy 3000 Pleasant 6000 Wild 3

DIVECUST Customer_No Name Street City State_Prov Zip_Postal_Code Country Phone First_Contact DEST DIVEORDS Destination_No Destination_Name Avg_Temp_F Avg_Temp_c Spring_Temp_F Spring_Temp_C Summer_Temp_F Summer_Temp_C Fall_Temp_F Fall_Temp_c Winter_Temp_F Winter_Temp_C Order_No Customer_No Sale_Date Ship_Via Ship_Cost Payment Method CcNumber CcExpDate No_Of_People Depart_Date Destination VacationCost DIVEITEM Order_No | Item_no Rental_Sale Qty Line_Note Accomodations BIOLIFE Night_Life Body_of_Water Travel_Cost Species No Category DIVESTOCK Item_No Description SHIPWRCK Ship_Name Site_No Common_Name Species_Name Length_cm Length_in Notes Equipment_Class On_Hand Reorder_Point Cost Category Type Interest Tonnage Length_ft Length_m Beam_ft Sale_Price Rental_Price SITES Site_NO Destination_No Site_Name Site_Highlight site_Notes Distance_from_Town_m Distance_from_Town_km Depth_ft Depth_m Visibility_ft Visibility_m Current Skill_Level BIOSITE Species_No Site_No Beam_m Cause Date_Sunk Comments Passengers_Crew Survivors Condition_1 Graphic_file