Use the diagram below to write SQL statements for each of the following below and create sentence along with the SQL statements.

For example:

SENTENCE: List employee hire dates and first and last names in that order. SQL Statement:

Select HireDate, FirstName, LastName From Employees Order by HireDate, FirstName, LastName

Use the diagram below to write SQL statements for each of the following below and create sentence along with the SQL statements.

1. Process applications

2. Review applications

3. Deny license request

4. Approve license request

5. Renew license

6. Submit application

7. Upload supplement documentation

8. Answer applicant questions/emails

9. Create user profile

10. Send out decision letters

Reports:

11. Professional complaints

12.CE Providers accreditation

13. Updated government regulations/statues

14. Licensure statistics

15. Number of denials

16. Number of approvals

17. Applications received

18. Number of facilities accredited by National Organizations

19. Disciplinary actions per licensure type

20. suspensions, probation,dismissals

21. Most frequent and most important reports.

22. Licensure statistics (BY MONTH?)

23. Number of disapproved applications

24. Number of approvals

25. Applications received (BY MONTH/YEAR?)

26. Number of licenses renewed (BY MONTH/YEAR?)

27. Less frequent and important reports

28. Professional complaints (qualitative data)

29. CE Providers accreditation (qualiftative data)

30. Updated government regulations/statues (qualitative data)

31. Number of facilities accredited by National Organizations

32. Disciplinary actions per licensure type

Professional CE Provide FEN stName stName Provider LastName LastName submit Gende starte Date Address Main Ph ane Numbe Application Enrollment quellifies lment SSN Enrollment Status ioense Type ID Code Renevu License ID Nur Decision Date SectionID Term Qual SSN ApplicationID License Ty Qual Name Section Section structor Provider ID CECourselD Section Number License Degree Type SSN Term School sue Date Null Room icenseTypeID Graduation Date Expiration Date Decision Date Approve dByID ExpirationDate ApplicationID Document Title QualificationType Submission Date Review ByID ApplicantFirst Name Qual cationName ApplicentLast Name DocumentDescription Received From Received Date QualificationID Docume nt Status DMQAStaff DocumentStatusID Received Date Staff ID Not eviewedD Staff FirstName ApprovedDate ines StaffLast Name DisapprovedDate rtmentID pal License ID Renew allD Hire Date Position ID Staff need to relate to LoginID document or qua cation because they approve. One staff member per document. *Determines status Received, ApprovedDate, DisapprovedDate. If the last two are null, then it has been received nstructorEmployment FEI Employment Division cto Instructor1 SSN Instruct arStartDate CE Course QualificationTypeID ourse Name ourse Hou Doc and Qualification License Type Qual Qual nName particular type of license. For that license type, here are the things you have to do. Professional CE Provide FEN stName stName Provider LastName LastName submit Gende starte Date Address Main Ph ane Numbe Application Enrollment quellifies lment SSN Enrollment Status ioense Type ID Code Renevu License ID Nur Decision Date SectionID Term Qual SSN ApplicationID License Ty Qual Name Section Section structor Provider ID CECourselD Section Number License Degree Type SSN Term School sue Date Null Room icenseTypeID Graduation Date Expiration Date Decision Date Approve dByID ExpirationDate ApplicationID Document Title QualificationType Submission Date Review ByID ApplicantFirst Name Qual cationName ApplicentLast Name DocumentDescription Received From Received Date QualificationID Docume nt Status DMQAStaff DocumentStatusID Received Date Staff ID Not eviewedD Staff FirstName ApprovedDate ines StaffLast Name DisapprovedDate rtmentID pal License ID Renew allD Hire Date Position ID Staff need to relate to LoginID document or qua cation because they approve. One staff member per document. *Determines status Received, ApprovedDate, DisapprovedDate. If the last two are null, then it has been received nstructorEmployment FEI Employment Division cto Instructor1 SSN Instruct arStartDate CE Course QualificationTypeID ourse Name ourse Hou Doc and Qualification License Type Qual Qual nName particular type of license. For that license type, here are the things you have to do