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 provide a SQL query 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!