Find the product names and total quantities ordered for each product in the "Ships" product line. Also, put the total number of rows while submitting as text. No screenshot is needed for this. Example output: productName 18th century schooner 1999 Yamaha Speed Boat HMS Bounty Pont Yacht The Mayflower The Queen Mary The Schooner Bluenose The Titanic The USS Constitution Ship Total sold 1011 966 897 958 898 896 934 952 1020
Added by Juan Manuel E.
Step 1
Step 1: Identify the "Ships" product line in the dataset. Show more…
Show all steps
Close
Your feedback will help us improve your experience
Akash M and 59 other Algebra educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
ORDER CUSTOMER CustID CName cPhone MOrdID ODate CustID (FK) ORDER LINE ProdID (FK) OrdID (FK) OrderQuantity PRODUCT ProdID PCost
Akash M.
Write a SELECT statement that answers this question: What is the total quantity purchased for each product within each category? Return these columns: The category_name column from the category table, The product_name column from the products table, The total quantity purchased for each product with orders in the Order_Items table. Use the WITH ROLLUP operator to include rows that give a summary for each category name as well as a row that gives the grand total. Use the IF and GROUPING functions to replace null values in the category_name and product_name columns with literal values if they're for summary rows.
What is the SQL command to list the number of product sales (number of rows) and total sales by month and product category, with subtotals by month and product category and a grand total for all sales? Figure P13.10 shows the result of the query.
Supreeta N.
Recommended Textbooks
Elementary and Intermediate Algebra
Algebra and Trigonometry
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD