I am to create a report that displays the vendor and credit information requested using the "Purchasing.Vendor" table in the AdventureWorksCTP3 database. Include the "Name," "Credit Rating," "Preferred," and "Active" fields. Export the report to Excel for submission. I am at the design query so what query would I need to use to get the following from Purchasing.Vendor table

Name, Credit Rating, Preferred, and Active fields.