Questions from Database Management

Q: How many tutors have a status of Temp Stop? Which tutors

How many tutors have a status of Temp Stop? Which tutors are active?

Q: What is the average Read score for all students? What are

What is the average Read score for all students? What are the minimum and maximum Read scores?

Q: List the IDs of the tutors who are currently tutoring more than

List the IDs of the tutors who are currently tutoring more than one student.

Q: What are the TutorIDs for tutors who have not yet tutored anyone

What are the TutorIDs for tutors who have not yet tutored anyone?

Q: How many students were matched with someone in the first five months

How many students were matched with someone in the first five months of the year?

Q: Based on Figure 1-5, what are the four perspectives

Based on Figure 1-5, what are the four perspectives from which you will explore transactional systems in this book? What are the main competencies associated with each of these perspectives?

Q: Which student has the highest Read score? /

Which student has the highest Read score?

Q: Show the average, maximum, and minimum Read score per student

Show the average, maximum, and minimum Read score per student group.

Q: How long had each student studied in the adult literacy program?

How long had each student studied in the adult literacy program?

Q: Which tutors have a Dropped status and have achieved their certification after

Which tutors have a Dropped status and have achieved their certification after 4/01/2018?