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.

Further refine the report you created in step 1 by vendors that currently have no orders. Use the "Purchasing.ProductVendor" table. Include "Min Order Qty," "Max Order Qty," and "On Order Qty." Export the report to Excel for submission.