Scenario 3: I want to know how many invoices for Vendor number 123 is greater than $50.

Scenario 4: I want to know the address of all vendors we have in the state of California, Ohio, or New Jersey. I want the street address City, State and Zip-code returned as a human would write them. I do not want any NULLs returned.

Scenario 5: I want to know the Contact Name and Number for each Vendor not in California, Ohio, or New Jersey that has a value of Null for the Phone Number. The result set should return the Vendor Name, Vendor Contact First and Last Name, Vendor State, and VendorPhone organized by state.