Please write query for each one Student Table Count of Distinct First Names Count of Distinct Last Names Count of Distinct Advisors Count of students per Major Enrollment Table Count of Students by Grade What percent of students have each grade Course Table Count of Courses Offered by Department Number of Majors Count of Majors Offered Number of Faculty Count of Distinct First Names Count of Distinct Last Names Count of Faculty per job Percent of Faculty are in each job Suggest a possible threshold based on the profiling in step 3.iv to help use in the future to inform whether or not the data being loaded appears to be valid. This would be represented as the percentage of records by distinct value that you believe makes sense. Note there is no wrong answer here Faculty by job Enrollment by student grade

Please write query for each one

1. Student Table
   1. Count of Distinct First Names
   2. Count of Distinct Last Names
   3. Count of Distinct Advisors
   4. Count of students per Major
2. Enrollment Table
   1. Count of Students by Grade
   2. What percent of students have each grade
3. Course Table
   1. Count of Courses Offered by Department
4. Number of Majors
   1. Count of Majors Offered
5. Number of Faculty
   1. Count of Distinct First Names
   2. Count of Distinct Last Names
   3. Count of Faculty per job
   4. Percent of Faculty are in each job
6. Suggest a possible threshold based on the profiling in step 3.iv to help use in the future to inform whether or not the data being loaded appears to be valid. This would be represented as the percentage of records by distinct value that you believe makes sense. Note there is no wrong answer here
   1. Faculty by job
   2. Enrollment by student grade