I would like some help in these questions for an assignment for…

Question Answered step-by-step I would like some help in these questions for an assignment for… I would like some help in these questions for an assignment for networking. Use tables in HR database to answer the following questions: Question 1 :What is the average salary of the employees who were hired after August 2006My code so far for question 1:SELECT Department_Name, AVG(salary) AS ‘AVG Sal’Question 2: Type a select statement that returns the number of departments that are located in Toronto Question 3: Type a select statement that returns all the employees whose job title is Stock ClerkQuestion 4: Type a select statement that returns the job title and the department name of Jennifer Whalen You must use SQL Server SQL (Transact SQL) to write the SQL statements Computer Science Engineering & Technology Networking CMAP 27198 Share QuestionEmailCopy link Comments (0)