Print the ids, states, and vendor contact last names of vendors in Wisconsin or vendors in California that have…

Print the ids, states, and vendor contact last names of vendors in Wisconsin or vendors in California that have…

Question:

 

Transcribed Image Text:

Print the ids, states, and vendor contact last names of vendors in Wisconsin or vendors in California that have vendor contact last names ending with the lower case letter sequence: ren. Your query is required to use a SQL set operator. VENDOR_ID VENDOR_STATE 1 2 3 1 WI 64 CA 79 CA VENDOR_CONTACT_LAST_NAME Alberto Oren Warren

Expert Answer:

Answer rating: 100% (QA)

Answer SELECT VENDOR ID VENDOR STATE VENDOR C
View the full answer