title: List the account-number, balance, loan-number and amount address using left join
body: <p>so I have this question and i tried to solve it like this:</p>
  
  <pre><code>select account.account_number,account.balance loan.loan_number,loan.amount from account LEFT JOIN loan ON account.branch_name=loan.branch_name';
  </code></pre>
  
  <p>I have the tables as follow:
  <a href="https://i.stack.imgur.com/WSaW6.png" rel="nofollow noreferrer">table1:account,table2:loan</a> .
  it shos me this error.</p>
  
  <pre><code>ERROR 1064 (42000): You have an error in 
  your SQL syntax; check the manual that 
  corresponds to your MySQL server version 
  for the right syntax to use near '';
  
  select 
  account.account_number,account.balance 
  loan.loan_number,loan.amount f' at line1 
  </code></pre>
  
  <p>and this one I honestly did not get it at all so if someone can explain to me how to solve it I will be thankful.
  Find the total amount each branch has in accounts.
  I have these tables as follows:<a href="https://i.stack.imgur.com/EdG2y.png" rel="nofollow noreferrer">tables</a>
  please help and thank you.</p>