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

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