How to use SUM and COUNT and add the results as a resulting column
<pre><code>CREATE TABLE my_table ( bank_account, bank_id, amount ) AS
SELECT 123, 600, 1500 FROM DUAL UNION ALL
SELECT 123, 600, 2500 FROM DUAL UNION ALL
SELECT 123, 600, 3500 FROM DUAL UNION ALL
SELECT 123, 700,  500 FROM DUAL UNION ALL
SELECT 123, 700, 1000 FROM DUAL UNION ALL
SELECT 456, 800, 2000 FROM DUAL UNION ALL
SELECT 456, 900, 2000 FROM DUAL UNION ALL
SELECT 456, 900, 4000 FROM DUAL;
</code></pre>

<p>I need to write the SQL code where the result would look like this:  </p>

<p><a href="https://i.stack.imgur.com/bvHVQ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bvHVQ.jpg" alt="enter image description here"></a></p>

<p>Where:<br>
<strong>total_amount</strong> - the sum of all transactions bank_account made in specific bank_id<br>
<strong>number_of_transactions</strong> - number of transactions made by bank_account in specific bank_id
<strong>total_num_trans</strong> - total number of transactions made by bank_account<br>
<strong>total_am_trans</strong> - total amount of transactions made by bank_account</p>

<p>I've only managed to get some of the results I need, but can't get them all.
This is with what I've started:</p>

<pre><code>  SELECT t.bank_account
       , t.bank_id
       , count(*)       number_of_transactions
       , sum(t.amount)  total_amount
    FROM my_table t 
GROUP BY t.bank_account
       , t.bank_id
ORDER BY t.bank_account
</code></pre>

<p>Thanks.</p>