Column Name Data Type Note food_id int This is t…
Column Name Data Type Note food_id int This is the primary key; auto generated by DB. name var_char(128) price float quantity int Write the SQL for these for four items using the table above. The name of the table is FOOD. Write a SELECT that returns the primary key and the name of all the foods that have a price greater than $10.00. Write an UPDATE that finds the food with the food_id equal to 42, and sets its quantity to 5. Write an INSERT that inserts the following food item: name: Oreos price: $4.99 quantity: 15 Write a DELETE that removes all foods with a quantity of 0. Do not write any PHP in your answer. Each query is 5 points.