pls help me with these SQL questions

Here are tables

TEAM table

Task 10 (4 marks) Write an SQL statement to display fan categories, the number of tickets in each category the fan bought (change the alias to "NUMBER OF TICKETS PURCHASED") along with the sum of prices (change the alias to TOTAL PRICES') in each category the fans paid. Sort the result by total price in an ascending order. Task 11 (5 marks) Write an SQL statement to display match ID and the count of tickets sold for each match ONLY if the number of tickets sold of this match is more than 1 and the open year of the stadium on which the match will be played is not 2013. Task 12 (5 marks) Write an SQL statement to display the stadium name and the number of matches played in each stadium (change the alias to "NUMBER OF MATCHES"). Display only the top two stadiums where most matches were held. Sort the result by the number of matches played on each stadium in a descending order. NOTE: Do Not use a static (fixed) value to determine the largest number of matches] Task 13 (5 marks) Write an SQL statement to display team name and its manager if Croatia is one of the teams in any match (either as a first or a second team). Manager's name should be displayed as initialisation of first name followed by a dot and then the last name. The alias of the manager column should be changed to "Manager Initials". For example, if manager's name is David Smith, it will be displayed as D. Smith