Q5. This is Exercise #8 of end of Chapter 4 (p.157)

Use the UNION operator to generate a result set consisting of two columns from the Vendors table:

VendorName and VendorState. If the vendor is in California, the VendorState value should be CA;

otherwise, the VendorState value should be Outside CA. Sort the final result set by VendorName.