I would like to know how to select the number of records in a table where only values greater than 6 are selected, but in each result it would be different with the MySql database, for example:
Tabela Notas
Unidade I | Unidade II | Unidade III | Unidade IV
10 | 4 | 7 | 3
1 | 3 | 7 | 9
7 | 0 | 8 | 1
Where values greater than 6 will appear like this in the query;
Unidade I | Unidade II | Unidade III | Unidade IV
2 Registros | 0 Registros | 3 Registros | 1 Registro