Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

In this lab you will write the 10 SQL statements against the STUDENT schema in Oracle.

/in /by

In this lab you will write the 10 SQL statements against the STUDENT
schema in Oracle. 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.

-Add yourself as a new student to the Student table (use sequence STUDENT_ID_SEQ.NEXTVAL as Student_ID and 07070 as zip)
-List all zipcodes (zip, city, state) that belong to NY state, and the city is either New York or Long Island City
-Show how many students who have phone area code 212 (HINT: use COUNT and LIKE operator)
-List all student names who work for Electronic Engineers and whose last name is not Grant nor Garnes
-Delete your own student record added for query 4

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"