title: Mysql returning OK but with no results
body: <p>When I try to run a select statement with subqueries in mysql workbench I encounter an OK response with no results (the query is successful). I am sure the code is alright and mysql also doesn't find any error, but I don't know why I don't get any answer.</p>
  
  <p>Here's the code</p>
  
  <pre><code>SELECT date(created_at),
      (SELECT 
              SUM(amount) AS topup_amount
          FROM
              wallet_transaction
          WHERE
              type = 'topup'
          GROUP BY DATE(created_at)),
      (SELECT 
              SUM(amount) AS admin_add_amount
          FROM
              wallet_transaction
          WHERE
              type = 'admin_add'
          GROUP BY DATE(created_at))
  FROM
      wallet_transaction;
  </code></pre>