sql = SELECT * FROM [Sports Events] WHERE SPORTSBET14 = 'Football-NFL' AND STATUS='Live' ORDER BY TRUST_RANK_NO DESCsqlC = SELECT count(*) AS num_rec FROM [Sports Events] WHERE SPORTSBET14 = 'Football-NFL' AND STATUS='Live'