Question 9. The following schema and respective domain information is given:

RECIPE [recipeID, recipeName, preparationTime, difficulty, uploadDate, Style]

RESTAURANT [restaurantName, openingHours] RESTAURANTRECIPE [restaurantName, recipeID, price] RECIPE.difficulty can have the following values: Easy, Advanced, Hard RECIPE.preprationTime is given in hours

uploadDate is given in the format of dd/mm/yyyy

Same attribute name implies foreign key e.g. RECIPEINGREDIENTS.recipeID references RECIPE.recipeID

Formulate the following questions in SQL. a) List details of Advanced recipes that have a preparation time of less than 4 hours.

b) Find the recipes that no restaurants offer.