Question
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started