22 . (faculty) 20 8 Grade First Question: Solve this question based on the tables given in the classroom: 1. Insert into faculty table given below, the first and the second records only. (3points) ! ! ) f_id loc_id f_rank f_first f_last f_pin Full Mu'taz Hamed 2000 J Adel Hasweh 2010 Hani Alhassan 3000 22 12 Sameeh Attare 23 13 Assistant Jaber Abuzaid 21 10 E 2. Update the student state so that it does not accept except the values "IL", "FL", "NY", "OH", and "WA". (3points) ans Fid as it Loc id as fi Frank as ny F first as oh Flast as wa 3. Display the term id and status for the terms that have the letter "0" as the third and the sixth letter in their term description. (3points) Ans Select term-id, status Srom term Where deseription=%%; List every class in the student table, sorted in descending order, and suppress duplicates. (3points) ans Select *from student Order by desc 4. Modify the course name to Database 1", and the credits to null for course number "BUS 200". (3points) 5. Delete all records from the faculty table that have the rank "Assistant' or have no rank. (3 points) ans Delete from faculty Whre rank = assistant 6. Retrieve term id, course name, and credits for course number "MIS 101' for none empty credits. (4 points) 22 . (faculty) 20 8 Grade First Question: Solve this question based on the tables given in the classroom: 1. Insert into faculty table given below, the first and the second records only. (3points) ! ! ) f_id loc_id f_rank f_first f_last f_pin Full Mu'taz Hamed 2000 J Adel Hasweh 2010 Hani Alhassan 3000 22 12 Sameeh Attare 23 13 Assistant Jaber Abuzaid 21 10 E 2. Update the student state so that it does not accept except the values "IL", "FL", "NY", "OH", and "WA". (3points) ans Fid as it Loc id as fi Frank as ny F first as oh Flast as wa 3. Display the term id and status for the terms that have the letter "0" as the third and the sixth letter in their term description. (3points) Ans Select term-id, status Srom term Where deseription=%%; List every class in the student table, sorted in descending order, and suppress duplicates. (3points) ans Select *from student Order by desc 4. Modify the course name to Database 1", and the credits to null for course number "BUS 200". (3points) 5. Delete all records from the faculty table that have the rank "Assistant' or have no rank. (3 points) ans Delete from faculty Whre rank = assistant 6. Retrieve term id, course name, and credits for course number "MIS 101' for none empty credits. (4 points)