SQL Server

1. Create a stored procedure that takes a Recipe Name as input and the output is a list of ingredients with Qty and Measurement Unit.

2.Create a Stored Procedure that takes ingredient name as input and gives a list of all the recipes that either do not use this ingredient or use this ingredient in a quantity less than 1 gram.

3.Create a list of ingredients, which are used by pounds for any recipe.

4.Create a script to print the month which has the maximum number of recipes submitted.

Reclnads RecipePropertv Property Ingds ProplD PropertyName RID 7 Ingdld Ingdld ProplD Mesurld IngdName Qty Persons Person!D FirstName LastName AddressID Recipes RID RName Mesmts RecipeOwners person!D Mesurld RecipeDate MDesc RID Addresses Address!D StAddress City StateCode Zip States RecipeCats RID CID StateCode StateName Categories CatName