- SELECT aluno.primeiro_nome,
- aluno.ultimo_nome,
- COUNT(aluno_curso.curso_id) numero_cursos
- FROM aluno
- JOIN aluno_curso ON aluno_curso.aluno_id = aluno.id
- GROUP BY 1, 2
- ORDER BY numero_cursos DESC
- LIMIT 1;
- SELECT curso.nome,
- COUNT(aluno_curso.aluno_id) numero_alunos
- FROM curso
- JOIN aluno_curso ON aluno_curso.curso_id = curso.id
- GROUP BY 1
- ORDER BY numero_alunos DESC
- LIMIT 1;
Re: Untitled 
From Gamboge Terrapin, 3 Years ago, written in Plain Text.
This paste is a reply to
">A PHP Error was encountered
Severity: Notice
Message: Trying to access array offset on value of type bool
Filename: view/view.php
Line Number: 33
A PHP Error was encountered
Severity: Notice
Message: Trying to access array offset on value of type bool
Filename: view/view.php
Line Number: 33
A PHP Error was encountered
Severity: Notice
Message: Trying to access array offset on value of type bool
Filename: view/view.php
Line Number: 33
Embed
Download Paste or View Raw
Hits: 54
