Class Meetings - Bb Collab x Module 1: Course Introduct XM school" (2) - dabakera X Get Homework Help With + at.edu/webapps/assessment/take/take jsp?course_assessment_id=_186324_1&course_id=_3549750_1&content_id= 3807600_1&question_num_3.x=0.. Remaining Time: 3 hours, 30 minutes, 01 second. Question Completion Status: Question 3 10 points Save Answer Consider the following relational schema. Departments(deputName string manager IDe string) Employees(campIDstring empName. string dateHired: date, salary: integer, deptName; string) Projects(pro/Ne string projName: string started Date: string budget: decimal, expectedDuration: string, projManagerID: string) Assigns(empID:string projNe string hours: string rate: integer) The meaning of these relations is straightforward, for example, the table Assigns has one record per worker project pair. The primary key for each table is underlined. The schema has the following five foreign keys The attribute manager ID of the table Departments that references table Employees, The attribute deptName of the table Workers that references tablo Departments, The attribute proyManagerID of the table Projects that references table Employees, The attribute empID of the table Assigns that references table Employees, and The attribute projNo of the table Assigns that references table Projects. Task: Write the following query in SQL. Note that you have to write exactly one SQL statement for each question. Also, the query answers must not contain duplicates, but you should use the SQL keyword distinct only when necessary. Q: Find the names and numbers of projects that have a budget less than the average budget o 5:12 PM 33 92 994 Class Meetings - Bb Collab x Module 1: Course Introduct XM school" (2) - dabakera X Get Homework Help With + at.edu/webapps/assessment/take/take jsp?course_assessment_id=_186324_1&course_id=_3549750_1&content_id= 3807600_1&question_num_3.x=0.. Remaining Time: 3 hours, 30 minutes, 01 second. Question Completion Status: Question 3 10 points Save Answer Consider the following relational schema. Departments(deputName string manager IDe string) Employees(campIDstring empName. string dateHired: date, salary: integer, deptName; string) Projects(pro/Ne string projName: string started Date: string budget: decimal, expectedDuration: string, projManagerID: string) Assigns(empID:string projNe string hours: string rate: integer) The meaning of these relations is straightforward, for example, the table Assigns has one record per worker project pair. The primary key for each table is underlined. The schema has the following five foreign keys The attribute manager ID of the table Departments that references table Employees, The attribute deptName of the table Workers that references tablo Departments, The attribute proyManagerID of the table Projects that references table Employees, The attribute empID of the table Assigns that references table Employees, and The attribute projNo of the table Assigns that references table Projects. Task: Write the following query in SQL. Note that you have to write exactly one SQL statement for each question. Also, the query answers must not contain duplicates, but you should use the SQL keyword distinct only when necessary. Q: Find the names and numbers of projects that have a budget less than the average budget o 5:12 PM 33 92 994