please answer all 5 parts. they should be straight forward questions that i just need assist in. kind regards. thumbs up for all 5 questions answered :))

The Tx IceCream table records the type of ice-cream associated with each sale. There may be more than one ice- cream associated with each sale. The IceCream and Store tables record information about each type of ice-cream and store respectively. The attributes that end in "_id" are primary keys for the corresponding table. Where one of these attributes appears in another table, it is a foreign key that references the table where it is a primary key. Q1. An analyst wants to "count the transactions for each icecream during the month of November. Write one or more SQL statements that will produce the result desired. Q2. Find the unique store ids of stores that had sales in March (month of 3) Q3. Find the unique names of ice-creams sold in March (month of 3) Q4. Find the total value, average value, and number of all ice-cream sales within each month Q5. Determine the top 3 stores by total store sales. Only qualify stores with an average sale value of at least 5 dollars. Present the result in a reasonable order