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.
yes im stumped...I cant figure how to convert a value in the query such as california to CA
I don't think that's what the question is asking, although it may be related (for the "Outside CA" part). I think you'll find that the database has some VendorState values that are: CA
so you need to write a SELECT statement that identifies those (very simple) and then UNION that with another SELECT statement that selects those VendorState values that are <> 'CA'
The trick (as i am a novice also) is how to make the VendorState column report back Not in CA
for the rows where VendorState <> 'CA'