I need assistance with answering SQL Inquiries in Oracle. On the task we created three tables which are stated below:

I need to develop tables ICECREAM, INGREDIENT and RECIPE with appropriate primary and foreign keys in word and then create them in ORACLE that is (Creating statement with appropriate PK, FKs in word) - Loading the data in ORACLE and also provide table structure and content 

ICECREAM (Ice_cream_ID, Ice_cream_flavor, price per scoop, year_first_offered, sellling _status)

INGREDIENT ( Ingredient_ID, Ingredient_name, cost)

RECIPE (Ice_cream_ID, ingredient_ID, quantity_used)

WHERE:

Ice_cream_ID is the internal Id given to an ice cream.

Ingredient_ID is the internal Id given to an ingredient

selling_staus is an internal control which keeps track of ice cream sales as high, low, medium or none. If no figures are available this field has no value.

Year_first_offered is the year that ice cream flavor was first offered

quantity_used is the amount of ingredient used in one pint of ice cream.

Sample of the data below:

What I need helped in answering in the queries in SQL: 1. What are the ingredient names? 2. Which ice cream flavored were offered before 2010 3. How many flavored were offered before 2012. 4. Give the ingredients used in both ice creams 540 and 101. 5. What are the ice cream flavors that use ingredient 1100? 6. Give the total quantity used per pint of ingredient 1000? 7. How many flavors were introduced each year? 8. How many ingredients have an 's' and an 'a' in their names in that order? 9. How many ingredients are in each ice cream flavor? 10. Give the names of ice creams that do not have selling status. 11. Give the total quantity of each ingredient used. 12. Give the count of ice creams by their selling status. 13. Give the count of icecream's that have at least two r's in their names. 14. Add an ice cream peanut butter id number 625 and uses ingredients 1500 and 1600. Note: It is a two step process Add ice cream first Assign ingredients

ICECREAM table IcecreamID Ice cream. Flavor Price per Selling status low high high low 101 201 211 311 321 405 406 407 510 520 525 540 545 550 560 Berry Vanilla Cherry Chocolate Strawberry Pistachio Almond Blackberry Mint Cookie Green Tea Raspberry Banana Pineapple coconut scoop $6 $2 $3 $3 $2 $2.50 $3 $4 $1.50 $2 $4.50 $3 $1.50 $2 $3.25 year first offered 2012 1981 1976 1981 1961 2012 2010 2015 1998 2001 2012 2012 1992 2001 2012 medium medium low medium high medium RECIPE Table Ice cream ID 101 540 545 101 201 407 101 201 311 321 101 540 545 405 406 201 540 211 101 520 Ingredient ID 1000 1000 1000 1100 1100 1200 1200 1200 1200 1300 1300 1300 1400 1400 1400 1500 1500 1500 1700 1700 Quantity used/pint 30 75 55 40 45 25 20 45 40 35 80 50 15 10 27.5 10 5.5 60 5 10 INGREDIENT Ingredient ID 1000 1100 1200 1300 1400 1500 1600 1700 1710 Ingredient name Cost/pint cocoa $125 Vanilla beans $30 Tea leaves $35 Raw almonds $215 Mint Leaves $42 Sugar $5 Cream $25 Pistachio $45 raspberry $12