note 74861 deleted from ref.mysql by tularis
| From: | tularis@php.net | Date: | Tue, 01 May 2007 09:19:11 +0000 |
| Subject: | note 74861 deleted from ref.mysql by tularis | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-126013@lists.php.net to get a copy of this message | ||
Note Submitter: Halit YEÅÄ°L mail [at] halityesil.com
Reason: useless
----
to calculate the students' end of year mark in school data base with one query
SELECT
student.snumber AS 'Student Number',
student.name AS 'First Name',
student.lastname AS 'Last Name',
SUM( smarks.smark ) AS 'Total Mark',
COUNT( * ) AS 'Total Lesson',
(SUM( smarks.smark ) / COUNT( * )) AS 'Marks End Of Year'
FROM
students AS student
LEFT JOIN
smarks
ON
smarks.student_id = student.id
LEFT JOIN
lessons AS lesson
ON
lesson.lesson_id = smarks.lesson_id
GROUP BY
student.snumber
ORDER BY
'Marks End Of Year' DESC
http://www.mysqlturkiye.org to check Turkish examples,take
a look at this adress