Given the table PRODUCT$($ProductID$,$ ProductName, ProductClass, ProductWeight, ProductStyle, ProductColor, ProductPrice$).$ Note: ProductWeight and ProductPrice are numeric fields, and the other attributes are character fields, i$.$e$.,$ store text.

Write a SQL query to retrieve all details of products whose name is "Watermelon" and whose color is "green".