Question: please help 3- (a) You are given a table of employees, working in different branches of a bank, with the following attributes: employee_ID, Position, First
please help

3- (a) You are given a table of employees, working in different branches of a bank, with the following attributes: employee_ID, Position, First Name, Last Name, Salary, Branch_ID. The "Position" column is an integer which is 1 for employees with a managerial role and 0 for employees without a managerial role. Use the SQL statements to complete the following tasks. (i) Write a query to list all employees' IDs, first names, and last names with salaries between 30000 and 60000 in ascending order based on their salaries. [10% ] (ii) Write SQL queries to find the count of managers and the average, minimum, and maximum managerial salaries. [10%] (iii) Write a query to find the average salary of employees in each branch and sort the output in ascending order according to the branch number. [15%] (iv) Use the SQL statements to increase the salaries by 2% and 3% in the table for the employees with and without a managerial role, respectively. [15%] (b) The following table shows the number of men and women buying different genres of books from a shop. Use the appropriate test to determine if there is a significant relationship between gender and the genre of the book. [35%] Genre Science Romance History Fiction Horror novel Gender Male 68 187 93 67 Female 41 103 107 113 (c) Explain what problem we may encounter if not using the activation function in neural networks. [15% ]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
