Answer Happy

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. Destination Accommodations Average Name Cost New Jersey Expensive 6000 Monterey Expensive 11333.33333... Santa Expensive 13800 Barbara Fiji Expensive 15000

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