Question 10 4 Pts Insert Orders Customerid Order Date Shipamount Taxamount Shipaddressid C Q26109584

Question 10 4 pts INSERT INTO orders customer.id, order date, ship_amount, tax_amount, ship_address.id, cardtype, card_number, car d.expires, billing.address.id) INSERT INTO order_items Corder_id, product.id, item_price, discount_amount, quantity) SELECT LAST INSERT_IDO, product.id, list price, ROUNDCCdiscount_percent/100) list price, 2), 1 FROM products p WHERE discount_percent>e AND list_priceSELECT AVGClist price) FROM products) AND category-id = (SELECT category_id FROM categories WHERE category-name- Guitars) ORDER BY list price; When you code a column list in an INSERT statement like above, you can omit columns with default values and columns that allow values O NULL O referential implicit integer O key

Question 10 4 pts INSERT INTO orders customer.id, order date, ship_amount, tax_amount, ship_address.id, cardtype, card_number, car d.expires, billing.address.id) INSERT INTO order_items Corder_id, product.id, item_price, discount_amount, quantity) SELECT LAST INSERT_IDO, product.id, list price, ROUNDCCdiscount_percent/100) list price, 2), 1 FROM products p WHERE discount_percent>e AND list_priceSELECT AVGClist price) FROM products) AND category-id = (SELECT category_id FROM categories WHERE category-name- “Guitars’) ORDER BY list price; When you code a column list in an INSERT statement like above, you can omit columns with default values and columns that allow values O NULL O referential implicit integer O key Show transcribed image text

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *