SQL 更新数据：将最贵商品供应商修改为 CCNU

UPDATE products SET supplier_id = 'CCNU' WHERE price = (SELECT MAX(price) FROM products);

SELECT * FROM products WHERE price = (SELECT MAX(price) FROM products);

-- 成功更新后，查询该产品信息会显示其供应商已经被修改为 CCNU。