单选题

如何删除sales表中产品类型为toys的profits列的列值？

Question

A. UPDATE sales SET profits = NULL WHERE product_type = 'TOYS'

B. DELETE profits FROM sales WHERE product_type = 'TOYS'

C. DELETE FROM sales WHERE product_type = 'TOYS'

D. DELETE FROM sales