title: Python queryto get height price user with count
body: <p>I have two tables like :</p>
  <h2>User:</h2>
  <h2>Id  |  Name | Age |</h2>
  <p>1 | Pankhuri | 24</p>
  <p>2 | Neha     | 23</p>
  <p>3 | Mona     | 25</p>
  <h2>And another
  Price log:</h2>
  <h2>Id  |  type | user_id | price | created_at|</h2>
  <p>1 | credit  | 1 | 100 | 2021-03-05 12:39:43.895345</p>
  <p>2 | credit  | 2 | 50  | 2021-03-05 12:39:43.895345</p>
  <p>3 | debit   | 1 | 100 | 2021-03-04 12:39:43.895345</p>
  <p>4 | credit   | 1 | 100 | 2021-03-05 12:39:43.895345</p>
  <p>These are my two tables from where i need to get heighst credit price user with their total price  count acoording to last week date..</p>
  <p>i want a result like :</p>
  <p>like if i want to get result for user id 1 then result should be like:
  pankhuri on date 04/03 price 100</p>
  <p>and on date 5</p>
  <p>pankhuri on date 05/03 price 200</p>
  <p>want only heighst price user in retirn with their price total on date basisi.</p>