Graduate Essay Writers
Only the most qualified writers are selected to be a part of our research and editorial team, with each possessing specialized knowledge in specific subjects and a background in academic writing.
Get Similar Asssignment Answers & Custom Paper Writing Services
To hire a writer, fill the order form with details from your nursing assessment task brief.
Posted: February 1st, 2024
Write a query using the books and publisher tables- Database Management System
Write a query using the books and publisher tables- Database Management System
Practice Exercise
Oracle Joins and Sub Queries
This exercise uses the same tables you have been using for your labs. Sign on to Oracle using your own user id and password.
Follow these steps to complete this exercise:
Write your queries in a script file.
Debug your script file either as you go along or after you finish writing all four queries.
Create a spooled or HTML output file using your script file. Be sure to SET ECHO ON before you create your spool output.
Submit the output file, the script file, and this exercise sheet with your name on it through the Dropbox.
QUERIES
Using the traditional join method, write a query using the ORDERITEMS and BOOK tables to list the order number, book title, and retail amount of the book ordered. Format the retail amount to reflect dollars and cents using the correct function and give the retail amount column and alias of “Cost.”
Rewrite the query in #1, only this time, use a NATURAL JOIN operator to create the join. Your output should be the same.
Write a query using the BOOKS and PUBLISHER tables that will show all of the publishers’ names and related book titles, even those publishers who do not currently have any books listed in the BOOKS table. HINT: this will require an OUTER JOIN
Write a sub query using the BOOKS and PUBLISHER table to list the ISBN, book title, and the retail price for every book in the BOOKS table published by AMERICAN PUBLISHING. Format the book price to show a dollar sign and two decimal places by using the correct conversion function.
Write a sub query using the ORDERITEMS table that will return only the ISBN of the book that has been bought most often. This process will require you to obtain the maximum total number of books ordered (based on ISBN) and then compare that to total books ordered, grouped by ISBN. Remember that sub queries work from the bottom up so the process described here is starting with the second query, not the first (remember this exercise when doing #5 in the lab).
Tags: pay someone to write a paper for you, Write my dissertation for me online in Ireland, Trending Dissertation Topics & Ideas For, Thesis Topics for Your Final Academic Project, Pay for dissertationWhy Seek Our Custom Writing Services
Every Student Wants Quality and That’s What We Deliver
Affordable Prices
Our prices strike the perfect balance between affordability and quality. We offer student-friendly rates that are competitive within the industry, without compromising on our high writing service standards.
100% Plagiarism-Free
No AI/chatgpt use. We write all our papers from scratch thus 0% similarity index. We scan every final draft before submitting it to a customer.
How it works
When you decide to place an order with Nursing Study Bay, here is what happens:
For Similar Answers, Custom Essay Writing & Assignment Help Services
Find an expert by filling an order form for your nursing paper. We write AI-plagiarism free essays and case study analysis. Anytime!