I want the payer code, payer name, payer category code, example inpatient visit, inpatient count, facility name, and facility code. Right now my code only outputs the following: payer code, payer name, payer category code, example inpatient visit. Please edit the below code so that it will include inpatient count, facility name, and facility code in the output as well.

SELECT DISTINCT

code,

$$name$,$

payer$\_$category$\_$code,

$\text{'}$https:$//\text{'}||($select value

$$from configuration$\_$option

$$where config$\_$key $=$ 'customerId'

$)$

$||\text{'}.$test'$||$visits$.$visit$\_$id$||\text{'}123\text{'}$ example$\_$inpatient$\_$visit

FROM payer p

LEFT JOIN $($SELECT

$$split$\_$part$($payers$,\text{'},\text{'},1)$ payer

$,$max$($visit$\_$id$)$ visit$\_$id

$$FROM visit

$$WHERE $($pre$\_$disch$\_$admit$\_$status $=1$ OR admit$\_$status $=1)$

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

$$AND facility is not null

$$AND loc$\_$poc is not null

$$GROUP BY $1$

$)$visits ON visits.payer $=$ p$.$code

UNION

SELECT DISTINCT

vp$.$plan$\_$id

$,$ vp$.$company$\_$name

$,$ 'NOT MAPPED'

$,\text{'}$https:$//\text{'}||($select value

$$from configuration$\_$option

$$where config$\_$key $=$ 'customerId'

$)$

$||\text{'}.$test'$||$visits$.$visit$\_$id$||\text{'}123\text{'}$ example$\_$inpatient$\_$visit

FROM visit$\_$payer vp

LEFT JOIN payer p ON p$.$code $=$ vp$.$plan$\_$id

LEFT JOIN $($SELECT

$$split$\_$part$($payers$,\text{'},\text{'},1)$ payer

$,$max$($visit$\_$id$)$ visit$\_$id

$$FROM visit

$$WHERE $($pre$\_$disch$\_$admit$\_$status $=1$ OR admit$\_$status $=1)$

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

$$AND facility is not null

$$AND loc$\_$poc is not null

$$GROUP BY $1$

$)$visits ON visits.payer $=$ vp$.$plan$\_$id

WHERE p$.$code IS NULL

AND vp$.$creation$\_$date $>=$ NOW$()-$ INTERVAL $\text{'}30$ days'

ORDER BY $1,2,3$;

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!