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

please help 3- (a) You are given a table of employees, working

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!