Here is the schema for it

Please use Oracle SQL to write SQL statements. I need it as soon as possible. Thank you.

ASSIGNMENT 1 (SQL) Use the attached schema for this assignment . Write a select statement that returns the number of teachers who teach DBAS32100 . Write a SQL statement that returns the name of the programs that have the most students in every campus. . Write a SQL statement that returns the name of the courses that a teacher with teacher ID 1233 teaches. Also return the program of the course, and the campuses name where the courses are taught. . Write a SQL statement that returns the students whose GPA is higher than the average GPA of the students who are in the same program. . Write SQL statement that return programs in Davis campus that have tuition fee > 12000 Instructions Deliver one .sql file that contains the questions and the select statements. You must use Oracle SQL to write the SQL statements. Any other variation of SQL will result in a zero mark for the questions. Badbo.Campus e Columns Campus_ID (PK, int, not null) Campus_Name (varchar(24), null) Campus_Address (varchar(24), null) Campus_City (varchar(12), null) 1 dbo. Program Columns 7 Program_ID (PK, int, not null) Program_Name (varchar(24), null) Program_Description (varchar(2000), null) Tuition_Fees (numeric(7,2), null) P Program Coordinator_ID (FK, int, null) 7 Campus_ID (FK, int, null) T dbo.Course Columns Course_ID (PK, int, not null) Course_Name (varchar(24), null) Course_Semester (varchar(24), null) Program_ID (FK, int, null) Teacher_ID (FK, int, null) dbo.Student Columns Student_ID (PK, int, not null) Student_Name (varchar(24), null) Student_Type (varchar(24), null) Student Admission_Date (date, null) i Student_GPA (numeric(3,2), null) Program_ID (FK, int, null) Bdbo. Teacher Columns Teacher_ID (PK, int, not null) Teacher_Name (varchar(24), null) Teacher_Salary (numeric(3,2), null)