Determine which orders had a higher total amount due than order 1008.

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

Learning Goal: I’m working on a business and need to help me learn.Scenario 7You are the rock star of the office yet again. You proved that you could retrieve data from orders grouped by customer, customers by state, profit by publisher, or any other number of attributes grouped by another attribute. In fact, you developed an executive summary report with descriptive statistical findings for your boss to review at the end of last week. He was extremely impressed with your work. In fact, your report was so impressive it led to revisiting the conversation about your future. Welcome to your first week of full-time work at JustLee Books as a data analyst! Your boss has planned an after-work social at the pub next door to welcome you to the team officially. When you arrive at the office, your boss asks to see you. He shares that subqueries are very helpful, and now he is interested in how you can write more dynamic queries that don’t have to be changed every time the underlying data changes. (ERD – Figure 1.5 is attached).Image credits: Photo of People Holding Each Others’ Hands, Canva.Work Project DetailsMore specifically, your boss wants you to learn a different approach from separate queries that involves using a subquery to achieve the same output using a single SQL statement. He wants you to be thinking about when it is appropriate to use subquery and the type of subquery that can be used in a SELECT clause. He will be out of the office again this week, but he walks you through your next small project. He wants you to work through the following exercises to help you practice with more dynamic queries:Determine which author or authors wrote the books most frequently purchased by customers of JustLee Books.
List the title of all books in the same category as books previously purchased by customer 1007. Don’t include books this customer has already purchased.
List the shipping city and state for the order that had the longest shipping delay.
Determine which customers placed orders for the least expensive book (in terms of the regular retail price) carried by JustLee Books.
Determine the number of different customers who have placed an order for books written or co-written by James Austin.
Determine which books were published by the publisher of The Wok Way to Cook.
List the book title and retail price for all books with a retail price lower than the average retail price of all books sold by JustLee Books.
Determine which books cost less than the average cost of other books in the same category.
Determine which orders were shipped to the same state as order 1014.
Determine which orders had a higher total amount due than order 1008.
Lato (Recommended)19px (Default)

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services