DSC HW #5

DSC HW #5 - Sarah Lowery DSC 340 951010439 Homework #5 PART...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Sarah Lowery DSC 340 951010439 Homework #5 PART A 1. a) SELECT FirstName, LastName FROM Students WHERE Trainer=3 AND Gender=’Female’ FirstNam e L a s t N a m e Tilda S p o n s l e r Margareta O q u i n n Josefina M e h a n Marguerit e C r i s m a n Katina W a
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
i n s c o t t Meta V i t e l l o b) 2. a) SELECT TrainerID, COUNT(DISTINCT StudentID) FROM Students, Trainers WHERE Gender='Male' AND Height>=72 GROUP BY Trainer b) Trainer Count 1 2 2 3 3 3 3. a) SELECT Track, AVG(Time) AS "AVG. TIME" FROM TrainingHistory GROUP BY Track ORDER BY Time DESC b) Track AVG. TIME 5 106.0846666 2 105.9853333 6 102.7328125 4 48.61393939 3 46.30395348 1 28.274375
Background image of page 2
4. a) SELECT Race, COUNT(Student) AS "Num. Of Students" FROM CompetitionsRoster WHERE Race<=3 OR Race>7 GROUP BY Race b) Race Num. Of Students 1 5 2 2 3 5 8 6 9 2 10 6 PART B 1. a) SELECT TrainerID, COUNT(DISTINCT StudentID) FROM Students, Trainers WHERE Trainer=TrainerID AND Tenure>=6 AND Gender='Female' AND Height>=64 GROUP BY Trainer b) TrainerID
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

DSC HW #5 - Sarah Lowery DSC 340 951010439 Homework #5 PART...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online