Using a subquery, write a statement that displays all vendors from the state of Texas. Include the columns: ...

Transcribed Image Text:

Using a subquery, write a statement that displays all vendors from the state of Texas. Include the columns: • vendor_name • vendor_city • vendor_state Your statement must include: • The IN keyword followed by your subquery • A subquery in the WHERE clause that returns a single state • A full SELECT statement as your subquery Activate Windows

Answer rating: 100% (QA)

sql SELECT vendor name vendor city vendor state FROM vendors WHERE ve View the full answer