Create a view named NumberOfBedrooms using the Bdrms column and a count of all condos of each bedroom size. Display the data in the view. Create the following indexes. If it is necessary to name the...

Create a view named NumberOfBedrooms using the Bdrms column and a count of all condos of each bedroom

size. Display the data in the view.

Create the following indexes. If it is necessary to name the index in your DBMS, use the indicated name.

a. Create an index named OwnerIndex1 on the State field in the Owner table.

b. Create an index named OwnerIndex2 on the LastName field in the Owner table.

c. Create an index named OwnerIndex3 on the State and City fields in the Owner table and list the states in

descending order.