sql = SELECT * FROM [Slots] WHERE PM_DINERS_CLUB = 'Diners Club' AND STATUS='Live' ORDER BY TRUST_RANK_NO DESCsqlC = SELECT count(*) AS num_rec FROM [Slots] WHERE PM_DINERS_CLUB = 'Diners Club' AND STATUS='Live'