[Solved] Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, = ,

by


I see this in a comment:

i need more than one value

Okay. Let’s run this as a real query then:

SELECT NombrePelicula, 
    (SELECT SUM(pelicula.PrecioEntrada) FROM pelicula) / count(*) As Recaudacion
FROM funcion  
GROUP BY NombrePelicula 
HAVING COUNT(*)>1

solved Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= ,