Looking at the data below, Please write a SQL query in order to achieve the result requested. Desired Output:

PAT$\_$ID

PAT$\_$NAME

TEMP

BLOOD PRESSURE

PATIENT CONSCIOUS

MOA

$123$

Justin, Bieber

$99\mathrm{.}8$

NULL

YES

NULL

$456$

Lionel, Messi

$97\mathrm{.}3$

$120/80$

NULL

Ambulance

$789$

Dwayne, Wade

NULL

$115/78$

NULL

Helicopter