Recipe_Classes TableRecipeClassIDRecipes TableRecipeClassIDselect Recipes.RecipeTitle, Recipes.Preparation, Recipe_Classes.RecipeClassDescription from RecipesINNER JOIN Recipe_ClassesON Recipes.RecipeClassID = Recipe_Classes.RecipeClassIDselect Recipes.RecipeTitle, Recipes.Preparation, Recipe_Classes.RecipeClassDescription from Recipe_ClassesINNER JOIN RecipesON Recipes.RecipeClassID = Recipe_Classes.RecipeClassIDSelect R.RecipeTitle, R.Preparation, RC.RecipeClassDescription fromRecipe_Classes AS RCINNER JOIN Recipe AS RON RC.RecipeClassID = R.RecipeClassIDWHERE RC.RecipeClassDescription in ('Main course', 'Dessert') SELECT R.RecipeTitle, R.Preparation, RCF.RecipeClassDescriptionFROM (SELECT RecipeClassID, RecipeClassDescription FROM Recipe_Classes AS RCWHERE RC.ClassName in ('Main course','Dessert')) AS RCFINNER JOIN Recipes AS RON RCF.RecipeClassID = R.RecipeClassIDRecipe_Classes TableRecipeClassID - Key 1RecipeClassDescriptionRecipes TableRecipeClassID - Key 1RecipeTitlePreparationRecipeID - Key 2Recipe_Ingredients TableRecipeID - Key 2RecipeSeqNoAmountIngredientID - Key 3Ingredients TableIngredientID - Key 3IngredientNameMeasureAmountID - Key 4Measurements TableMeasureAmountID - Key 4MeasurementDescriptionSELECT Recipe_Classes.RecipeClassDescription, Recipes.RecipeTitle, Recipes.Preparation,Recipe_Ingredients.RecipeSeqNo, Recipe_Ingredients.Amount, Ingredients.IngredientName,Measurements.MeasurementDescription FROM ((((Recipe_ClassesINNER JOIN RecipesON Recipe_Classes.RecipeClassID = Recipes.RecipeClassID)INNER JOIN Recipe_IngredientsON Recipes.RecipeID = Recipe_Ingredients.RecipeID)INNER JOIN IngredientsON Recipe_Ingredients.IngredientID = Ingredients.IngredientID)INNER JOIN MeasurementsON Ingredients.MeasureAmountID = Measurements.MeasureAmountID)SELECT Products.ProductNumber, Products.ProductName, Categories.CategoryDescriptionFROM ProductsINNER JOIN Categories ON Products.CategoryID = Categories.CategoryIDSELECT DISTINCT Customers.CustFirstName, Customers.CustLastNameFROM (((CustomersINNER JOIN OrdersON Customers.CustomerID = Orders.CustomerID)INNER JOIN Order_DetailsON Orders.OrderNumber = Order_Details.OrderNumber)INNER JOIN ProductsON Order_Details.ProductNumber = Products.ProductNumber)WHERE Products.ProductName Like ('*Helmet*')