Please depending on the tables information I need the answers for "view".... in SQL language Thank You.

Create Works ON Table: ESSN: Employee Social Security Number (Primary key) + (Foreign Key) PNO: Project Number (Primary Key) + (Foreign Key) HOURS: Project Working Hours Create Project Table: PNAME: Project Name PNUMBER: Project Number (Primary key) PLOCATION: Project Location DNUM: Department Number which Project belongs to (Foreign Key) O Create Department Table: DNAME: Department Name DNUMBER: Department Number (Primary Key) DLOCATION: Department Location MGRSSN: Manager Social Security Number (Foreign Key) MGRSTARTDATE: Manager Work Start Date Create new Database named: Company Create Employee Table: FNAME: First Name LNAME: Last Name SSN: Social Security Number (Primary key) BDATE: Birth Date ADDRESS: Employee's Address Gender: F (Female) OR M (Male) SALARY SUPERSSN: Emplyee's Supervisor SSN DNO: No. of the Department the Emp. Works in (Foreign Key) 9. View the names and numbers of all departments located in Dammam or Dharan. 10- View the names of all projects which hours is greater than 20. 11- View all employees whose first names contain the letter a as the second character. 12- View employee number of all employee who the birth date in 1958. 1 13- View all project number who their location begin with letters K or R