Use the following Database structure to answer questions. The PK in each table is labeled with a key icon. The tables are linked via the FK-PK relationship. 1 and infinity indicate 1 to many relationship. For each question, you have to select a single best answer. Customer Customer D LastName FirstName Age Gender Address City State Zip Phone Credit CardType Credit CardNumber ExpirationDate Booking Booking D Customer D GuidelD BookingDate Hours 00 BookingDetail DetaillD BookingID ProductID Guide GuidelD LastName FirstName Age Gender Address City State Zip Phone 00 Product ProductID ProdName Category Supplier D HourlyRate UnitsinStock Supplier Supplier D Company Address City State Zip Phone Question 1 We want to know how many bookings for each product. What tables will appear in the FROM clause of the query? BookingDetail, Product, Guide BookingDetail, Product, Guide, Supplier Customer, Booking Detail, Product O O BookingDetail, Product Question 2 We want to know how many bookings for each product. How many conditions appear in the WHERE clause? 2 T 1 pts A 1 pts Question 3 We want to know how many bookings for each customer who is female. What tables will appear in the FROM clause of the query? Customer, Booking, Guide Customer, Booking, Product O BookingDetail, Booking, Customer Question 4 O Customer, Booking We want to know how many bookings for each customer who is female. How many conditions appear in the WHERE clause? 2 3 1 pts 4 1 1 pts Question 5 We want to list all female guides whose trips have been booked more than 5 times. What tables will appear in the FROM clause of the query? Customer, Booking, Guide Booking Details, Booking, Guide O Customer, Guide Question 6 O Guide, Booking We want to list all female guides whose trips have been booked more than 5 times. How many conditions appear in the WHERE clause? 4 2 1 pts 3 1 1 pts Question 7 We want to list all female guides whose trips have been booked more than 5 times. How many conditions appear in the HAVING clause? Question 8 2 We are interested in: for each supplier, how many customers are located in same city (Assuming the city attribute is enough to differentiate one city from another). How many tables do we need for this query? O O 2 1 pts 4 1 pts Question 9 We are interested in: for each supplier, how many customers are located in the same city (Assuming the city attribute is enough to differentiate one city from another). How many conditions appear in the WHERE clause? 3 N 1 Question 10 group by CustomerID We are interested in: for each supplier, how many customers are located in the same city (Assuming the city attribute is enough to differentiate one city from another). Which condition will appear in the GROUP BY clause? group by City 1 pts group by ProductID group by Supplier D 1 pts