Question 1 Each vendor in Vendors table is preassigned a DefaultTermsID Find the total vendors that have DefaultTermsID 2 by writing a SELECT statement with GROUP BY Question 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

Answer rating: 100% (QA)

Here are the SQL queries you need Query for update statement UPDATE vendors SE... View the full answer