Write 10 SQL statements against the STUDENT schema

Write 10 SQL statements against the STUDENT schema you checked for practice . Your statements should run error-free and should be valid. Submit two separate files: one plain text file (.txt or .sql file) with your statements only;

A.  The SQL script must be a text file saved with the extension .txt Please use plain text editor such as Notepad. Do not use MS Word as it might use special characters that will cause errors when the script is run. For example, MS Word normally uses left and right  “smart quotes” which Oracle does not recognize. If you use Word to create your script, ensure you turn off the curly quotes as this will cause an error in Oracle. To do this you usually go to the "Options" area, find "Proofing", then "AutoCorrect" and "AutoFormat". Under "Replace", uncheck "Straight quotes" with "smart quotes".

B.  You may want to put script comments in your script file to document your work. If you do, ensure to indicate to Oracle that your notes are "comments" and not SQL commands. Oracle will error on non-commented notes. For more details please check sites such as  https://docs.oracle.com/cd/B14117_01/server.101/b10759/sql_elements006.htm

Q1. Display all information about all courses that have no prerequisite

Q2. Add yourself as a new student to the Student table (use sequence STUDENT_ID_SEQ.NEXTVAL as Student_ID and 07070 as zip)

Q3. List all students (display Student_ID, first name and last name) who live in zip 07070

Q4. Show how many students who have phone area code 212 (HINT: use the SUBSTR function)

Q5. List all student names who work for Electronic Engineers and registered on or after Feb. 3, 2007

Q6. List all courses that have "Intro to Information Systems" as prerequisite (HINT: use a subquery)

Q7. For all students who have phone area code 212, change the code to 202 while keeping the same phone number (HINT: consider using functions such as SUBSTR and LENGTH)

Q8. Delete your own student record added for query 2

Q9. Lower cost of all courses by 300

Q10. List all course costs (show course description and cost only) by the order of cost from lowest to highest (show courses without cost first)