10 sql statements | Computer Science homework help

10 sql statements | Computer Science homework help.


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)

10 sql statements | Computer Science homework help

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.