Find the total number of hours for each type of adventure to…
Find the total number of hours for each type of adventure tours, showing only tours with a total of more than 10 hours. What is the number of rows resulting from this query?Note: You must answer this question using the sample data provided. SELECT ProdName, SUM(Hours) AS TotalHoursFROM (Product INNER JOIN BookingDetail ON Product.ProductID = BookingDetail.ProductID) INNER JOIN Booking ON BookingDetail.BookingID = Booking.BookingIDWHERE Category = ‘Tour’GROUP BY ProdNameHAVING TotalHours > 10
Read Details