I NEED THEM AS SQL QUERIES IN MSSQL MANAGEMENT STUDIO

7. Create a procedure that transfers data from the project table to the projects_history table. 5. Create a function to calculate the net budget of all projects. 3. Create a procedure which increases the budget of all projects by a parameter until the sum of budgets is greater than $600,000. In other cases it prints appropriate information. 7. Create a function which returns the coefficient (sum of budget by the average budget value)