Write 10 SQL statements athwart the STUDENT schema you created for performance lab 1. Your statements should run error-free and should be powerful. Submit two disunited rasps: one open quotation rasp (.txt or .sql rasp) delay your statements simply; and the other muniment (doc/docx/pdf) embrace twain your statements and your interrogation developments (delineation and paste quotation or harbor shots). The educator and TA should be conducive to run your open quotation rise rasp as script and propagate the identical output as pompn in your development muniment.
Attached is Lab 1
1. Evidence all notification encircling all directions that entertain no prerequisite
2. Add yourself as a new ward to the Ward tconducive (use conconsequence STUDENT_ID_SEQ.NEXTVAL as Student_ID and 07070 as zip)
3. List all wards (evidence Student_ID, primeval designate and conclusive designate) who subsist in zip 07070
4. Pomp how multifarious wards who entertain phone area jurisprudence 212 (HINT: use the SUBSTR character)
5. List all ward designates who toil for Electronic Engineers and registered on or following Feb. 3, 2007
6. List all directions that entertain "Intro to Notification Systems" as prerequisite (HINT: use a subquery)
7. For all wards who entertain phone area jurisprudence 212, exexchange the jurisprudence to 202 suitableness maintenance the identical phone estimate (HINT: ponder using characters such as SUBSTR and LENGTH)
8. Delete your own ward annals acquired for interrogation 2
9. Lower require of all directions by 300
10. List all direction requires (pomp direction cognomen and require simply) by the dispose of require from last to foremost (pomp directions delayout require primeval)
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more