select count(vimisjournalquery_id), vimisjournalquery_inanswerdt::date from vimis.vimisjournalquery where vimisjournalquery_inparam like '%checkStatusResponse%' and vimisjournalquery_inanswerdt::date >= '2023-07-01'
group by vimisjournalquery_inanswerdt::date
order by vimisjournalquery_inanswerdt::date desc
