Use the two diagram below Northwind and Hospital data models diagrams to answer the following questions

1. Write a strored procedure that will receive two date values as parameters and return the customer company names, order ID values, and order dates for all orders placed during that period.

2. write a stored procedure that will receive all values needed for a new supplier except supplierID, create new supplier record, and return the value of the new record's supplierID in a RETURN statement. Set up the SP so that the default value for contry is 'USA.'

3. NORTHWIND: write a stored procedure that will receive A category name parameter and a country and return all product information for products in that category produced by suppliers from that country.

4. NORTHWIND: write a stored procedure that will receive all values needed for a new product except productID, create new product record, and return the value of the new record's productID in a RETURN statement. Set up the SP so that the default value for discontinued is 0 (ZERO).

1. Hospital Schedule Diagram Below

2. NorthWind Diagram Below

Bed Hat Room BedCount Bed Type Room Type occupied (y) DepartmentID Has Bed Assignment Has Admission Patient ID End Time StartTime BedNum EndTime Room Num Reason AdmissionID Admit PhysicianID Hass Orders Ha Patient Physician LastName LastName FirstName FirstName Gender Gender DOB LicenseNum Orders Has Procedure Order Type Procedure Name PatientID Description Has order Type PhysicianID OrderDate ProcedureID Lab Test Type LabTestID LabTestlD TestName Description Has Has Vitalsigns LabResults Performorder TestTime OrderID Results Results Performed ByID Performed ByID Performed ByID PerformTime OrderID Order ID Department DeptName Office Number CurrentMgrID Has Shift DepartmentID StartTime EndTime Has ShiftJob Quantity Has ShiftAssign JobTypelD Arrive Time DepartTime Takes Ha Has Ha Perform EmpAssignment EmployeeID DepartmentID JobTypeID EndDate Has Job Type JobName Description Has EmpJobQual StartDate EndDate Has Employee Last Name FirstName DateOf Birth Gender Title Has Manages