Write 10 SQL statements against the STUDENT schema you created for practice lab 1. 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; 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. Attached is Lab 1 1. Display all information about all courses that have no prerequisite 2. 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 07070 4. 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, 2007 6. 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 2 9. Lower cost of all courses by 300 10. List all course costs (show course description and cost only) by the order of cost from lowest to highest (show courses without cost first)
Looking for solution of this Assignment?
WHY CHOOSE US?
We deliver quality original papers |
Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected |
Free revisions |
We offer our clients multiple free revisions just to ensure you get what you want. |
Discounted prices |
All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount |
100% originality |
We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI |
On-time delivery |
We will deliver your paper on time even on short notice or short deadline, overnight essay or even an urgent essay |