Good afternoon, suppose I have a list of students with the list of subjects they passed, and I want to select the name of those who passed math and language, if I do:
SELECT nombreAlumno FROM alumno WHERE aprobo = matematica AND aprobo = lengua
This would not give any results since it approved would have to have those two values at the same time, and not each one separately, is there any query with which to do this in an easy and fast way? I mean, I would need something like the division of relational algebra, in which a data to be compared is given, with a list, in which the first data must be related to all the data in the list. Use mariadb.