PHP / mysql问题与输出查询

Question

I have this table in my database:

classes

id | classname | 


grades 

id | class_id | grade | date

I need to get the average of the grades and the latest grade based on the date + the correct classname.

I have this query but this doesn't output the correct classnames...

SELECT 
                AVG(grade),
                classes.classname,
                grades.grade,
                MIN(ABS(DATEDIFF(CURDATE(),'date')))
                FROM 
                grades, classes

                GROUP BY
                grades.grade_id

                ORDER BY grades.date DESC

Answer 1

Your question seemed a little vauge, so Im answering my interpretation of your question.

You didnt demonstrate what you got, but, Im going to guess you got a list of grades with an average by class, not classes with grades..

So, while I think theres a few questions in there. First.

select avg(grade), classname from classes 
left join grade on classes.id = grades.class_id 
group by classname

Should give you the average grade by class.

What is cijfers? you didnt really include much about that yet you also asked it to average it somehow.