1 point
47. You must update the 'price' column of all 'products' with a 'category' of 'Electronics' to set the price to $500.Which SQL statement should you use?
UPDATE products SET price = 500 WHERE category = 'Electronics';
ALTER TABLE products SET price = 500 WHERE category = 'Electronics';
MODIFY products SET price = 500 WHERE category = 'Electronics';
UPDATE products FROM category = 'Electronics' SET price = 500;