Use the following query to obtain the count of records available for each table in descending order (from high to low) - include conditions if necessary:

select distinct t.name as Table_Name,p.rows as Noof_Records from sys.tables t inner join sys.partitions p on t.object_id=p.object_id where create_date<='15-apr-2025'

order by p.rows desc