SELECT COUNT(DISTINCT plos.LedgerTransactionID) PatientCount,Round(ifnull(SUM(IF(plos.`IsSampleCollected`='R',0,plos.`PCCInvoiceAmt`)),0)) NetAmount FROM f_ledgertransaction lt INNER JOIN patient_labinvestigation_opd_share plos on plos.LedgerTransactionID=lt.LedgerTransactionID INNER JOIN f_panel_master fpm on fpm.Panel_ID=lt.Panel_ID and fpm.InvoiceTo=1281 WHERE lt.date>='2025-01-25 00:00:00' AND lt.date<='2025-01-25 23:59:59'