Write a Stored Procedure for the two statement below using the information in the VISIO diagram

1. Snapshot Report: The license applications that have supporting documents which have been reviewed and approved but are currently pending final approval.

2. Report with a Tabular Sub-Report: Currently open application details with a tabular sub report for each application with documents received. Application details include qualifications and qualification status.

Profe ssional CE Provider FEIN. ProviderFirstName FirstName Provider astName ast Name bmits Gender Starte Date Address MainPhone Number Application Enrollment qualifies Application ID Enrollm Enrollm ent StatusID license TypeID Code Renew License ID umber SubmissionDate SectionID has Decision Date Term Qualification has SSN cationID o Application License Type QualificationTypeID has icense Name Section equines requires SectionlD nstructorID Degree Lconana has icense ProviderID CE Course ID allif ion' QualificationTypeID Degree Type License Type License SectionNumber SSN Term School issue Date License TypeID Room Numbe Gradua Expiration Date ion Date Decision Date Approved BylD ExpirationDate Application ID receives Document ID Document Title Submission Date QualificationType ReviewBylD Applicant FirstName ific ionT eID ApplicantLastName QualificationName Document Description Received From Received Date QualificationID Revie WID ApprovalDate Document Status DenialDate ocument Status Received Date DMQAStaff NotReviewedD Approved Date Staff ID Disapproved Date StaffFirst Name dete StaffID Staff astName DepartmentID License RenewallD Date Position ID LoginID InstructorEmployment FEIN Employment Division Instructor struct orlD SSN uctorStart Date CE Course FEIN QualificationTypeID Course Number Course Name Course Hou has