Using the DiveShop database, create a query that returns the following table exactly as shown. You may use any resources
Posted: Sat May 14, 2022 4:26 pm
- 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 32 times
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