aggregate function or the GROUP BY clause MSSQL : I want to get the sum per day by its specified date , show the sum and the tenant name on it. It should be like this. Does it have any possible way to construct it right??

-----------------------------------
tenant_id tenant_name  Total Amount
  123      SAMPLE         37100

-----------------------------------

[enter image description here][1]


  [1]: https://i.stack.imgur.com/hFFr9.png