Determine which author or authors wrote the books most frequently purchased by customers of JustLee Books

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 immunology 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.
eric scoring method. You can give feedback on each criterion by tabbing to the add feedback buttons in the table.CriteriaLevel 420 pointsLevel 315 pointsLevel 210 pointsLevel 15 pointsCriterion ScoreMethodsStatistical methods were fully and correctly applied.Most methods were correctly applied but more could have been done with the data. Some methods were applied but with significant errors or omissions. Statistical methods were completely misapplied or absent.Score of Methods,/ 20Rubric Total ScoreTotalScore of Scenario/Assignment Rubric,/ 50Criterion score has been overriddenOverall ScoreOverall ScoreLevel 25 points minimumSubmit AssignmentFiles to submit(0) file(s) to submitSave your document with only letters and/or numbers in the name ensuring there are no spaces and special characters in the name of the file you are uploading, for example: * ” @ : # $ % ^ > etc.,After uploading, you must click Submit to complete the submission process.Add a FileRecord AudioRecord VideoCommentsParagraphLato (Recommended)19px (Default)

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services