Pergunta de entrevista da empresa Perspecta

2nd round: Given a School DB with Professor, Student, Class, Score tables. 1) How many classes does each professor teach? 2) Display AverageScoreForClass and AverageScoreForProfessor. 3) Write a SP to get a student’s score 4) Display StudentName, ClassName, MAX(Score) which got max score for each class. How to optimize a SSIS package? How to use Checkpoint?