Hello, this question is for Oracle SQL.

Task#7: write the sql statement for the following: a) Create a table named Foods which has the following columns: menu item as numeric of size 2 supplier_id as character type of 3, product_code as character type of 2, description varchar2(20), price price increase as numeric with scale and precision of 4, 2 as numeric with sca le and precilon o as numeric with scale and precision of 4, 2, b) Rename the product code to product id c) Add a check constraint to price column ensuring that price of all the items are less then $10.00 d) Add a unique constraint to description column