Where Clause

$1.(4$ pts$)$ Select the all columns of Sales.CustomerCategories for ID of $1.$

$2.(4$ pts$)$ Select just the name column from Sales.CustomerCategories for IDs that are not

equal to $1.$

$3.(4$ pts$)$ Output the id and names of all Sales.Customers$\_$Archive rows that have a

CustomerCategoryID $>2.$

$4.(4$ pts$)$ Output the id and name of all Sales.Customers$\_$Archive rows where the customer

is on credit hold $($bit columns are assigned as $0=$ False and $1=$ True$).$

$5.(4$ pts$)$ Output all names of Sales.Customers$\_$Archive rows where the name begins with

$$D$.$