Posts by Tiago Queirós • 1 point
1 post
-
0
votes0
answers86
viewsQ: SQL-Count for each id
I want to show all student table records - name and number - and then in the right column, show attendance percentage. Let’s see: SELECT nome, numero, ( ( SELECT COUNT(aluno.numero) FROM aluno JOIN…