my $statement = 
    q{ SELECT }. $tmp. 
    q{ FROM( SELECT }. $pvt_col. q{, count(*) AS }. $count. 
          q{ FROM }. $table.
          q{ GROUP BY }. $pvt_col. q{ WITH ROLLUP
           ) as temptbl;};

$sth = $dbh->prepare($statement);
....