The following a small part of a dataset about house prices in Washington State. Each row represents a house that has been sold and each column gives a characteristic of that house. Imagine that this dataframe is stored in $R$ with the name HOUSE.

$\backslash$table$[[$price$,$bedrooms,bathrooms,sqft$\_$living,sqft$\_$lot,floors,waterfront,view$],[221900,3,1,1180,5650,1$ No$,$None,$],[538000,3,2\mathrm{.}25,2570,7242,2,$No$,$None$],[180000,2,1,770,10000,1$ No$,$None,$],[604000,4,3,1960,5000,1,$No$,$None$],[510000,3,2,1680,8080,1,$No$,$None$],[1225000,4,4\mathrm{.}5,5420,101930,1,$No$,$None$],[257500,3,2\mathrm{.}25,1715,6819,2,$No$,$None$],[291850,3,1\mathrm{.}5,1060,9711,1$ No$,$None,$],[229500,3,1,1780,7470,1,$No$,$None$],[323000,3,2\mathrm{.}5,1890,6560,2,$No$,$None$],[662500,3,2\mathrm{.}5,3560,9796,1$ No$,$None,$],[468000,2,1,1160,6000,1,$No$,$None$],[310000,3,1,1430,19901,1\mathrm{.}5$ No$,$None,$],[--,-,--,---,---,-1,.-,]]$

It's desired to take a subset with houses that are at least $1$ million dollars, isn't $2$ bedrooms, and has No for waterfront. Which command$($s$)$ will produce this subset.

subset$($HOUSE$,$ price $1$ e $6$& bedrooms $2$& waterfront$=="{?}^{\text{'}\text{'}\text{'}})$

subset$($HOUSE$,$ "price" $>=1$ e $6$ & "bedrooms" $!2$ & "waterfront""No$")$

SELECT $*$ FROM HOUSE WHERE price $1000000$ AND bedrooms $=2$ AND waterfront $=\text{'}$No$\text{'}$

subset$($HOUSE$,$"price" $>=1$e$6,$ "bedrooms" $!=2,$ "waterfront"$=="$No$")$

subset$($HOUSE$,$ select$=$c$($price $1e6,$bedrooms! $=2,$waterfront$=$No$)$