Answer Happy

Posted: **Sat May 14, 2022 4:10 pm**

: Divecust Customer No Name Street City State Prov Zip Postal Code Country Phone First Contact Dest Diveords Destination N 1 (119.75 KiB) Viewed 36 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

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. Depth (m) Visibility (ft) 18.288 150 27.432 150 27.432 150 15.24 100 24.384 150 36.576 175 Name of Fish Species Length (cm) Site Name Blue Angelfish Pomacanthus 30 The W nauarchus Blue Angelfish Pomacanthus 30 Heron Island nauarchus Blue Angelfish Pomacanthus 30 Cutter Passage nauarchus Bluehead Wrasse Thalassoma 15 Yocab Reef bifasciatum Bluehead Wrasse Thalassoma 15 Santa Rosa Reef bifasciatum Bluehead Wrasse Thalassoma 15 Punta Sur bifasciatum Bluehead Wrasse Thalassoma 15 Palancar Reef bifasciatum Bluehead Wrasse Thalassoma 15 Crocker Valley bifasciatum Bluehead Wrasse Thalassoma 15 Conch Wall bifasciatum Bluehead Wrasse Thalassoma 15 Coffin's Patch bifasciatum Bluehead Wrasse Thalassoma 15 Chancanab Reef bifasciatum For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). 30.48 150 32.004 90 30.48 90 7.62 80 18.288 100