problemas com subquery multiplos resultados

Salve, Galera estou com uma dúvida estudando banco de dados e programação.

escrevi a seguinte query:

	[SELECT](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/select.html) data_pg as diaria, [SUM](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_sum)(valor_pg) as valor_diario, [SUM](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_sum)(valor_despesa) as valor_despesa, ([SELECT](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/select.html) [SUM](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_sum)(valor_pg) as dinheiro FROM pagamento WHERE tipo = 5 [AND](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_and) MONTH(data_pg) = 06 [AND](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_and) [YEAR](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/date-and-time-types.html)(data_pg) = 2019) as total_dinheiro, ([SELECT](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/select.html)[SUM](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_sum)(valor_pg) as debito FROM pagamento WHERE tipo = 25 [AND](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_and) MONTH(data_pg) = 06 [AND](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_and) [YEAR](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/date-and-time-types.html)(data_pg) = 2019) as total_debito, ([SELECT](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/select.html) [SUM](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_sum)(valor_pg) as credito FROM pagamento WHERE tipo = 15 [AND](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_and) MONTH(data_pg) = 06 [AND](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_and) [YEAR](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/date-and-time-types.html)(data_pg) = 2019) astotal_credito FROM pagamento WHERE MONTH(data_pg) = 06 [AND](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/logical-operators.html#operator_and) [YEAR](http://localhost/phpmyadmin/url.php?url=http://dev.mysql.com/doc/refman/5.5/en/date-and-time-types.html)(data_pg) = 2019 GROUP BY diaria ORDER BY `diaria`

	 

	resultado:

 [diaria /applications/core/interface/imageproxy/imageproxy.php?img=http://localhost/phpmyadmin/themes/dot.gif&key=c39b4d9a986d4f284dc077b838fe56875d1a18f53ef808ec864420967a090e1a" style="border:0px;padding:0px;vertical-align:middle;" title="" data-imageproxy-source="http://localhost/phpmyadmin/themes/dot.gif" /> 1](http://localhost/phpmyadmin/sql.php?db=acmweb&table=pagamento&sql_query=SELECT+data_pg+as+diaria%2C+SUM%28valor_pg%29+as+valor_diario%2C+SUM%28valor_despesa%29+as+valor_despesa%2C%0A%28SELECT+SUM%28valor_pg%29+as+dinheiro+FROM+pagamento+WHERE+tipo+%3D+5+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_dinheiro%2C%0A%28SELECT+SUM%28valor_pg%29+as+debito+FROM+pagamento+WHERE+tipo+%3D+25+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_debito%2C%0A%28SELECT+SUM%28valor_pg%29+as+credito+FROM+pagamento+WHERE+tipo+%3D+15+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_credito+FROM+pagamento+WHERE+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019+GROUP+BY+diaria%0AORDER+BY+%60diaria%60++DESC&session_max_rows=25&is_browse_distinct=0&token=b7dd9e6a18dd705451e9faa41eed4034)

 [valor_diario](http://localhost/phpmyadmin/sql.php?db=acmweb&table=pagamento&sql_query=SELECT+data_pg+as+diaria%2C+SUM%28valor_pg%29+as+valor_diario%2C+SUM%28valor_despesa%29+as+valor_despesa%2C%0A%28SELECT+SUM%28valor_pg%29+as+dinheiro+FROM+pagamento+WHERE+tipo+%3D+5+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_dinheiro%2C%0A%28SELECT+SUM%28valor_pg%29+as+debito+FROM+pagamento+WHERE+tipo+%3D+25+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_debito%2C%0A%28SELECT+SUM%28valor_pg%29+as+credito+FROM+pagamento+WHERE+tipo+%3D+15+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_credito+FROM+pagamento+WHERE+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019+GROUP+BY+diaria%0AORDER+BY+%60valor_diario%60+ASC&session_max_rows=25&is_browse_distinct=0&token=b7dd9e6a18dd705451e9faa41eed4034)

 [valor_despesa](http://localhost/phpmyadmin/sql.php?db=acmweb&table=pagamento&sql_query=SELECT+data_pg+as+diaria%2C+SUM%28valor_pg%29+as+valor_diario%2C+SUM%28valor_despesa%29+as+valor_despesa%2C%0A%28SELECT+SUM%28valor_pg%29+as+dinheiro+FROM+pagamento+WHERE+tipo+%3D+5+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_dinheiro%2C%0A%28SELECT+SUM%28valor_pg%29+as+debito+FROM+pagamento+WHERE+tipo+%3D+25+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_debito%2C%0A%28SELECT+SUM%28valor_pg%29+as+credito+FROM+pagamento+WHERE+tipo+%3D+15+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_credito+FROM+pagamento+WHERE+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019+GROUP+BY+diaria%0AORDER+BY+%60valor_despesa%60+ASC&session_max_rows=25&is_browse_distinct=0&token=b7dd9e6a18dd705451e9faa41eed4034)

 [total_dinheiro](http://localhost/phpmyadmin/sql.php?db=acmweb&table=pagamento&sql_query=SELECT+data_pg+as+diaria%2C+SUM%28valor_pg%29+as+valor_diario%2C+SUM%28valor_despesa%29+as+valor_despesa%2C%0A%28SELECT+SUM%28valor_pg%29+as+dinheiro+FROM+pagamento+WHERE+tipo+%3D+5+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_dinheiro%2C%0A%28SELECT+SUM%28valor_pg%29+as+debito+FROM+pagamento+WHERE+tipo+%3D+25+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_debito%2C%0A%28SELECT+SUM%28valor_pg%29+as+credito+FROM+pagamento+WHERE+tipo+%3D+15+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_credito+FROM+pagamento+WHERE+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019+GROUP+BY+diaria%0AORDER+BY+%60total_dinheiro%60+ASC&session_max_rows=25&is_browse_distinct=0&token=b7dd9e6a18dd705451e9faa41eed4034)

 [total_debito](http://localhost/phpmyadmin/sql.php?db=acmweb&table=pagamento&sql_query=SELECT+data_pg+as+diaria%2C+SUM%28valor_pg%29+as+valor_diario%2C+SUM%28valor_despesa%29+as+valor_despesa%2C%0A%28SELECT+SUM%28valor_pg%29+as+dinheiro+FROM+pagamento+WHERE+tipo+%3D+5+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_dinheiro%2C%0A%28SELECT+SUM%28valor_pg%29+as+debito+FROM+pagamento+WHERE+tipo+%3D+25+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_debito%2C%0A%28SELECT+SUM%28valor_pg%29+as+credito+FROM+pagamento+WHERE+tipo+%3D+15+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_credito+FROM+pagamento+WHERE+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019+GROUP+BY+diaria%0AORDER+BY+%60total_debito%60+ASC&session_max_rows=25&is_browse_distinct=0&token=b7dd9e6a18dd705451e9faa41eed4034)

 [total_credito](http://localhost/phpmyadmin/sql.php?db=acmweb&table=pagamento&sql_query=SELECT+data_pg+as+diaria%2C+SUM%28valor_pg%29+as+valor_diario%2C+SUM%28valor_despesa%29+as+valor_despesa%2C%0A%28SELECT+SUM%28valor_pg%29+as+dinheiro+FROM+pagamento+WHERE+tipo+%3D+5+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_dinheiro%2C%0A%28SELECT+SUM%28valor_pg%29+as+debito+FROM+pagamento+WHERE+tipo+%3D+25+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_debito%2C%0A%28SELECT+SUM%28valor_pg%29+as+credito+FROM+pagamento+WHERE+tipo+%3D+15+AND+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019%29+as+total_credito+FROM+pagamento+WHERE+MONTH%28data_pg%29+%3D+06+AND+YEAR%28data_pg%29+%3D+2019+GROUP+BY+diaria%0AORDER+BY+%60total_credito%60+ASC&session_max_rows=25&is_browse_distinct=0&token=b7dd9e6a18dd705451e9faa41eed4034)

  

 2019-06-10

 818.70

 0

 288.40

 586.95

 113.30

 2019-06-11

 169.95

 0

 288.40

 586.95

 113.30

  

  

  

	 

	Como podem ver meu objetivo e separar por dia o resultado dos valores divididos por tipo de pagamento.

	porém o mesmo mostra a soma total nas subquery.

	quando coloco o group by order by dentro das subquerys apresenta a seguinte mensagem de erro: #1242 - Subquery returns more than 1 row 

	 

	 

	como resolver?