title: Write an SQL query to get every day's "end of day" balance for each "customer - account" combination
body: <pre><code>CREATE TABLE &quot;customer_account_info&quot; (
    &quot;customer_id&quot; bigint,
    &quot;account_number&quot; bigint,
    &quot;transaction_time&quot; timestamp,
    &quot;balance&quot; float
  );
  </code></pre>
  <p>Columns definition is as below</p>
  <pre><code>customer_id - Unique customer ID for each customer
  account_number - Unique account number for each account
  transaction_time - timestamp column for Date and Time of each transaction
  balance - Balance of the account after the transaction
  </code></pre>