My Query````mysql
<pre>
    SELECT results.subjects,
    MAX(CASE WHEN results.term = 'First' THEN results.examTotal END) 'First'
    ,MAX(CASE WHEN results.term = 'Second' THEN results.examTotal END) 'Second'
    ,MAX(CASE WHEN results.term = 'Third' THEN results.examTotal END) 'Third'
    FROM results
    WHERE studId = '".$RegNo."'
    GROUP BY   results.subjects
    ORDER BY results.subjects ASC
</pre>
````mysql ````

    <pre>
    I expect to have a table
    +-----+-------+--------+-----+----------+---------+---------+-------+
    +Sub  + First + Second +Third+(Total/3) + Highest + Average + Lowest+
    +-----+-------+--------+-----+----------+---------+---------+-------+
    + Eng +  79   +  80    +  67 +  75.33   +   80    +  60     +  45   +
    +-----+-------+--------+-----+----------+---------+---------+-------+
    +Maths+   60  +  77    + 73  +   70     +   90    +  60     +  40   +
    +-----+-------+--------+-----+----------+---------+---------+-------+
    </pre>