for name in dayj dptm tfj{1,2,3,4,5,6,7,8} tfx{1,2,3,4,5,6,7,8}
do
    echo "select count(*) from $name;" >> night_file.sql
done

% printf "select count(1) from tfg%d;\n" {1..10}
select count(1) from tfg1;
select count(1) from tfg2;
select count(1) from tfg3;
select count(1) from tfg4;
select count(1) from tfg5;
select count(1) from tfg6;
select count(1) from tfg7;
select count(1) from tfg8;
select count(1) from tfg9;
select count(1) from tfg10;