Topic: Subquery with sorting
Hello. I study SQL independently. Invented a problem. How it can be implemented theoretically? Here such trouble. We admit, it is necessary to implement the report in a type to the table. A vertical column are written pupils, and in a horizontal column of their estimation. It is necessary to deduce on intersection kol-in estimations.
It will be better to drive on SELECT COUNT (*) to each cell or somehow it is possible to use the temporary table?