Use Figure C (Issue Tracking Database) to answer the questions 11 through 16. TCSS445 Issue Tracking Database keeps track of issues (problems) within a company reported by its users which handled by its IT and software development teams ISSIIES Figure C: TCSS445 Issue Tracking Database How many tuples (records) will be returned as a result of executing the following SQL statement: SELECT PROJECTID, Name, Status FROM PROJECTS, ISSUES WHERE Priority = 'High' AND PROJECTS.ID = ISSUES.ID; If the result-set contains no records (i.e. empty), enter 0 as an answer. Otherwise, enter the numeric value of the number of records that will be returned. In the space provided below, write an appropriate SQL query which list the number of issues reported by each department. As part of the result-set, include the department (i.e. name) and the corresponding number of issues reported. In the space provided below, write an appropriate SQL query that will list all the information about the issues that have a high priority or are still open (e.g. have an open status). In the space provided below, write an appropriate SQL query that will list all of the issues with a closed status and relate to the 'Citrix Metaframe' project. Issue information (or the result table) must include issue id, priority, create date and assigned person. In the space provided below, write an appropriate SQL query that will list the names of users who created issues that have a closed status for any project that is handled by the IT department. Use an alias UserName for the user names and sort the results in a descending order of the UserName