I want a sql query that will give me an output with :the payer code, payer name, payer category code, example inpatient visit, inpatient count, facility name, and facility code. NOTE: You can get the inpatientcount

FROM general$\_$adt

$$ WHERE admit$\_$date $>$ NOW$()-$ INTERVAL $\text{'}30$ Days'

$$ AND patient$\_$class IN $(\text{'}$I$\text{'},$'INPATIENT','Inpatient',$\text{'}$IN$\text{'})$

GROUP BY $1,2$;

Here is some information about my tables; The payer table has the following: code, name, payer$\_$category$\_$code. The visit table has the following: visit$\_$id$,$ account$\_$no$,$ admit$\_$status, loc$\_$poc. The visit$\_$payer table has the following: plan$\_$id$,$ visit$\_$id$.$ The configuration$\_$option table has the following: config$\_$key. The facility table has the following: code, name. The location table has the following: facility$\_$code, code, name. The general$\_$adt table has the following: account$\_$no$,$ patient$\_$id$,$ visit$\_$no$.$ Please let me know if you have any questions!