Using SQL Server Management Studio (SSMS) 2016 or 2017:

4. Create the following indexes:

Create an index named OwnerState on the State field in the Owner Table.

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

Create an index named OwnerCityState on the State field and City field in the Owner table.