Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
Query 1. Each vendor in Vendors table is pre-assigned a [DefaultTermsID]. Find the total vendors that have DefaultTermsID 2 by writing a SELECT...
Query 1.Each vendor in Vendors table is pre-assigned a [DefaultTermsID]. Find the total vendors that have DefaultTermsID 2 by writing a SELECT statement with GROUP BY.
Query 2.Write a SELECT statement with GROUP BY and ORDER BY to find the DefaultTermsID in the Vendors table that is assigned to most vendors.
Query 3.Each vendor in Vendors table is pre-assigned a [DefaultAccountNo]. Write a SELECT statement with GROUP BY and ORDER BY to find the top three DefaultAccountNo that are given to the most vendors.
Query 4.Modify your statement of Query 3 in order to get the [AccountDescription] of the account that has the most vendors.
Query 5.In order to solve Query 4, the SELECT statement must include two column names in the GROUP BY. What are these two columns?
Query 6.In order to solve Query 4, the SELECT statement must join Vendors table with another table. Which is?
