sql = SELECT * FROM [Casinos] WHERE PM_PREPAID_ATM = 'Prepaid Card' AND STATUS='Live' ORDER BY TRUST_RANK_NO DESCsqlC = SELECT count(*) AS num_rec FROM [Casinos] WHERE PM_PREPAID_ATM = 'Prepaid Card' AND STATUS='Live'