Select Code to Download

my $query = qq{
select "t1" as t, count(*) as c from table_one
...
#    { t => 't1', c => 4 },
#    { t => 't2', c => 2 } 
# ];

my $query = qq{
SELECT 
...

my @table_status = $dbh->selectrow_array($query);
# @table_status = ( 4, 2 );