sql = SELECT * FROM [Bingo] WHERE PM_VISA_MC = 'Visa/MC' AND STATUS='Live' ORDER BY TRUST_RANK_NO DESCsqlC = SELECT count(*) AS num_rec FROM [Bingo] WHERE PM_VISA_MC = 'Visa/MC' AND STATUS='Live'