From the course: Advanced MySQL Database Administration

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Challenge: Creating and updating orders

Challenge: Creating and updating orders - MySQL Tutorial

From the course: Advanced MySQL Database Administration

Start my 1-month free trial Buy for my team

Challenge: Creating and updating orders

“

- [Instructor] All right, we are ready for your assignment on creating an order summary table. So, Sally's come to you, and she said that now that you have multiple products, she would love to have a table that's summarizing the full orders. She wants you to create a table that will capture the order_id, when the order was created, the website session-id that drove the order, the primary product_id, and also the total price and cost of goods sold in US dollars. She'd like you to back-populate this table after you create it using the records from the order_items table. So, just to be clear, you've already done the work to create the order_items table, and you have all this data stored on the central database. Now, Sally wants you to take that item-level data and roll it up to the order level in this new table. For those of you who have taken our Beginner and Advanced Analysis Courses, creating this back-population query that's going to summarize the orders will be no problem. For…

Contents