List of all table with row count and latest updated date for each categoy

Transact-SQL
1

Hello Team,

I have database with several tables and each tables having fields LastUpdatedDateime,Category and looking for query retive following result.

Table Name,cateogry, rowcount, Lastupdateddatetime
TableX 1 56 03-10-2022
TableX 2 1000 04-10-2022
TableY 3 500 03-10-2022

Thanks in advance,

2

What have you tried so far - and where are you having issues? The queries for each table are simple aggregate queries - grouping on Category column.