write the 10 SQL statements against the STUDENT schema in O
write the 10 SQL statements against the STUDENT schema in Oracle. (login information can be provided).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, I recommend you use notepad or wordpad ; and the other document (doc/docx/pdf) include both your statements and your query results (copy and paste text or screen shots). The instructor and TA should be able to run your plain text source file as script and generate the same output as shown in your result document. 1. Display all information about all courses that have no prerequisite2. Add yourself as a new student to the Student table (use sequence STUDENT_ID_SEQ.NEXTVAL as Student_ID and 07070 as zip)3. List all students (display Student_ID, first name and last name) who live in zip 070704. Show how many students who have phone area code 212 (HINT: use the SUBSTR function)5. List all student names who work for Electronic Engineers and registered on or after Feb. 3, 20076. List all courses that have ‘Intro to Information Systems’ as prerequisite (HINT: use a subquery)7. 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)8. Delete your own student record added for query 29. Lower cost of all courses by 30010. List all course costs (show course description and cost only) by the order of cost from lowest to highest (show courses without cost first)Learning Resourceshttps://www.w3schools.com/sql/sql_select.asphttps://docs.oracle.com/database/121/SQLRF/sql_elements009.htm#SQLRF51132I’ve also attached another Lab which completed with screen shots for your review.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
