Oracle SQL HomeWorks
Budget: $50 – $100 CAD
********** Hi , Looking for it to be done in a Day! please only send offers if you are able to do so :( ********
Using SQL Developer to execute the following queries. Using the Scripts 8, 9 fro the below questions:
*Write a query to display the order number and customer first and last name for each order using WHERE clause.
*Write a query to show the order number and the first and last names of customers who have ordered computer books. Use the JOIN...USING clause to join the tables.
*Write a query to show the title and ISBN of each book in the books table. If the book has been ordered, show the order number and order date. Use the OUTER JOIN keywords to join the tables. Sort the titles in alphabetical order.
*Write a query to show the gift a customer will receive if he or she orders Holy Grail of Oracle. Use either the WHERE clause or a JOIN keyword to join the tables.
*Write a query to show title and the profit of each book sold to Bonita Morales. Calculate the profit by subtracting the cost from the paideach column in the orderitems table. Use the NATURAL JOIN clause to the join the tables. Use the alias PROFIT for the profit column.
Please use SQL Developer to write the queries below: Use scripts 8 + 9 +10 to include all the data needed to answer these questions.
*Write a query that displays the first name and last name of each author with the first letters capitalized. Display the first name left justified (lined up on the left) with 12 characters and the last name right justified (lined up on the right) with 12 characters. Use aliases for the column headings and blanks to pad the data in the columns. You will need to nest one function inside another one.
*Write a query that shows the first and last name of each customer and whether or not the customer was referred by another customer. If they were referred, display "Referred," and if not, display "Not Referred."
*Write a SQL query that displays the full name of the day of the week, the hour, minutes and seconds of the computer you are using.
*Determine the amount of profit for order number 1004. Include the book title and the profit, with the profit formatted as dollars and cents. Use the paideach and cost columns to calculate the profit, and make sure to use the quantity purchased in case there was more than one copy of the book purchased.
*Using today's date, determine the length of time in months since each book was published. Display the title and publication date along with the number of months. Do not show fractional months, only whole numbers. Use an alias for the length of time.
if need be the data needed is not found you might need to run the data from JLDB_Build_5.sql .
If you take a look at the WhatsApp image attached as a file it is the pic of the SQL developer you are to use.
Using SQL Developer to execute the following queries. Using the Scripts 8, 9 fro the below questions:
*Write a query to display the order number and customer first and last name for each order using WHERE clause.
*Write a query to show the order number and the first and last names of customers who have ordered computer books. Use the JOIN...USING clause to join the tables.
*Write a query to show the title and ISBN of each book in the books table. If the book has been ordered, show the order number and order date. Use the OUTER JOIN keywords to join the tables. Sort the titles in alphabetical order.
*Write a query to show the gift a customer will receive if he or she orders Holy Grail of Oracle. Use either the WHERE clause or a JOIN keyword to join the tables.
*Write a query to show title and the profit of each book sold to Bonita Morales. Calculate the profit by subtracting the cost from the paideach column in the orderitems table. Use the NATURAL JOIN clause to the join the tables. Use the alias PROFIT for the profit column.
Please use SQL Developer to write the queries below: Use scripts 8 + 9 +10 to include all the data needed to answer these questions.
*Write a query that displays the first name and last name of each author with the first letters capitalized. Display the first name left justified (lined up on the left) with 12 characters and the last name right justified (lined up on the right) with 12 characters. Use aliases for the column headings and blanks to pad the data in the columns. You will need to nest one function inside another one.
*Write a query that shows the first and last name of each customer and whether or not the customer was referred by another customer. If they were referred, display "Referred," and if not, display "Not Referred."
*Write a SQL query that displays the full name of the day of the week, the hour, minutes and seconds of the computer you are using.
*Determine the amount of profit for order number 1004. Include the book title and the profit, with the profit formatted as dollars and cents. Use the paideach and cost columns to calculate the profit, and make sure to use the quantity purchased in case there was more than one copy of the book purchased.
*Using today's date, determine the length of time in months since each book was published. Display the title and publication date along with the number of months. Do not show fractional months, only whole numbers. Use an alias for the length of time.
if need be the data needed is not found you might need to run the data from JLDB_Build_5.sql .
If you take a look at the WhatsApp image attached as a file it is the pic of the SQL developer you are to use.