Write SQL code please. Tables are attached with their appropriate fields for reference.

The Marketing Department requires a vendor listing that shows the following fields: 1. - Vendor Name Vendor Contact First Name - Vendor Contact Last Name - Vendor City - Vendor State - Vendor Zip Code Note: Sort by vendor state The Finance Department requires a report that shows payment totals greater than $50.00. List the following fields 2. - Vendorid - Payment Total - Payment Date The Sales Department requires a report that shows all vendors who are located in the states of New York, Alaska, California and Florida. List all fields in the vendors table 3. Using the Vendor Contacts table, create a report that list the vendorid field. vendorid, what is the names of each vendor? 4. By