Write your answer as a MySQL query statement, execute it, and take a screenshot of the results. If the query result has more than 10 records, limit the output to the top 10 before taking the screenshot.

 

1.  Find all flowers that are either red and bloom in the summer. 

 

2.  Find all shops that have red flowers in stock.  

 

3.  Find the names of all shops that have in stock only two flowers from each family. 

 

4. List the names of all flowers along with their family names, excluding those in stock in shops located in Toronto, Montreal, or Ottawa. 

 

5.  Find the average quantity in stock for each flower available in shops located in Toronto. 

 

6.  Find the families that have more than 2 types of flowers. Return the Family ID and the count of flower types. 

 

7.  Find the family ID with the highest average quantity of flowers in stock across all shops.