MyQSL

Q.4) (15 points) Write an UPDATE statement that modifies two columns within the roww that you added in Question 3 above. This statement should change the tax_amount column to 4.20 and should change the card type to Mastercard my guitar_shop Tables addresses | Columns address id customer_id linel line2 city state zip_code phone disabled Indexes PRIMARY addresses_fk_customers Foreign Keys addresses_fk_customers addresses fk_customens > Triggers administrators admin_id email_address password first_name last_name ep Indexes PRIMARY Foreign Keys Triggers | categories Columns category_id category_name ep Indexes PRIMARY PRIMARY category-name Foreign Keys Triggers | | customers C] columns customer_id email address password first name last_name shipping-addressid billing-address-d - E Indexes PRIMARY emailaddress - Foreign Keys Triggers -order-items | order-items -Columns item_id orderid - product_id item-price discountamount - quantity Indexes PRIMARY items fk orders items_fk_products Foreign Keys items.fk-orders Triggers Columns items_fk_produds orders order-id order_id customer_id order date ship-amount tax amount ship_date ship-address-id card_type card_number card-expires billing address_id ep Indexes PRIMARY ordersfkcustomers - - VE Foreign Keys orders_fk_customers ] Triggers products [05] Columns order_id customer_id order date ship-amount tax amount ship_date ship-address-id card_type card_number card-expires billing address_id ep Indexes PRIMARY ordersfkcustomers - - VE Foreign Keys orders_fk_customers ] Triggers products [05] Columns o columns product_id category_id product-code product-name description list-price discount-percent dateadded - ep Indexes PRIMARY product-code products-fk. categories VE Foreign Keys products_fk_categories Triggers Views Stored Procedures Functions