For this challenge you need to create a simple SELECT statement. Your task is to calculate the MIN, MEDIAN and MAX scores of the students from the results table.
Tables and relationship below:
Student Table
id
Name
Result
id
student_id
score
Resultant table:
SELECT MIN(score) as min,MAX(score) as max
FROM student s JOIN result r
ON(s.id=r.id)
GROUP BY score as median;
this is my code everything works apart from median
I get an HTTP 502 as well. What's more, when I load the site landing page, I get a continuous "Connection lost…Reconnecting in" n "seconds". In Safari, this counts down from 10 to 0 and repeats forever. In Chrome, it counts down from 10, then 15, then 20, then 25 seconds.
McCoy: She's *dead,* Jim!