SQL Question please don't use chatgpt which make no sense to me.

Imagine you had a table named 'iron_rich_foods' as indicated below. 10 points Which query would show just the names and milligrams of iron per serving of all iron rich foods that have heme, ordered by the amount of iron per serving in descending order? (Note that many many SQL databases, including SQLite, do not have a boolean data type, and simply treat boolean values as integers, 1 or 0.).... Please note that the answer options for all questions about this data may mistakenly call the 'food' field 'name'... ignore that error - it is the 'food' field we are referring to.** SELECT * FROM iron_rich_foods WHERE has_heme=1 ORDER BY mg_iron_per_serving DESC; SELECT name, mg_iron_per_serving FROM iron_rich_foods WHERE has_heme=1 ORDER BY mg_iron_per_serving DESC; SELECT iron_rich_foods FROM name, mg_iron_per_serving ON has_heme=1 ORDER BY mg_iron_per_serving DESC; SELECT name, AVG(mg_iron_per_serving) FROM iron_rich_foods WHERE has_heme=1 ORDER BY mg_iron_per_serving DESC; Which field might possibly make sense to assign as the primary key? * 10 points food serving_size serving_units iron has_heme Which query would delete the record that represents the candied ginger * 10 points root?. DELETE FROM iron_rich_foods WHERE id =3; DELETE FROM iron_rich_foods WHERE id = "candied ginger root"; DELETE FROM iron_rich_foods WHERE serving_size =30 AND iron =3.4; DROP iron_rich_foods WHERE candied_ginger_root = TRUE; Which query would re-insert the record for candied ginger root? * 10 points CREATE iron_rich_foods (name TEXT "candied ginger root" PRIMARY KEY, serving_size INTEGER 30 , serving_units TEXT "g", iron, has_heme INTEGER 0); READ iron_rich_foods SET (name, serving_size, serving_units, iron, has_heme) VALUES ("candied ginger root", 30, "g", 3.4, 1); INSERT INTO iron_rich_foods (name, serving_size, serving_units, iron, has_heme) VALUES ("candied ginger root", 30, "g", 3.4, 1); UPDATE iron_rich_foods SET (name, serving_size, serving_units, iron, has_heme) VALUES ("candied ginger root", 30, "g", 3.4, 1); DELETE iron_rich_foods WHERE (name, serving_size, serving_units, iron, has_heme) = ("candied ginger root", 30, "g", 3.4, 1)