Question
Please use SQL Developer to write and run the queries below. Copy and paste your query code into the submission box. This assignment should be
Please use SQL Developer to write and run the queries below. Copy and paste your query code into the submission box. This assignment should be completed by July 19th.
Write a query that shows the total sales for an order date in 2009. Label the data "Total Sales in 2009".
Write a query that shows largest profit for books in the Computer category.
Write a query that displays each shipstate along with the number of orders shipped to that state. Display the results in descending order by state
Write a query that displays order number and the total paid for each order. Format the amount using dollars and cents. Label the total amount "Order Total."
Write a query to show the retail price of the most expensive book written by Lisa White.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started