In a table I have the following columns: nomeAluno , disciplina , numeroDeFaltas .
I need a VIEW that I can put the name of the student in the WHERE clause and it returns me the name of the discipline that this student has less faults, like this:
SELECT disciplina
FROM nomeView
WHERE nomeAluno = 'Marcos';