For this activity, we will using the AdventureWorksdatabase.
(Here is the link to download the sample database if needed.https://archive.codeplex.com/?p=msftdbprodsamples
Select the oltp file)
–Query 1–Which vendors have a credit rating greater than3?–Display the vendor name, credit rating and address (streetaddress,– city, state) for vendors that have a credit ratinghigher than 3.– Sort the list by vendor name.
Expert Answer
An answer will be send to you shortly. . . . .