MySQL Forums
Forum List  »  General

SQL Vendor Sort
Posted by: Can Atila
Date: April 02, 2021 02:18PM

In this MySQL challenge, your query should return the vendor information along with the values from the table cb_vendorinformation. You should combine the values of the two tables based on the GroupID column. The final query should consolidate the rows to be grouped by FirstName, and a Count column should be added at the end that adds up the number of times that person shows up in the table. The output table should be sorted by the Count column in ascending order and then sorted by CompanyName in alphabetical order. Your output should look like the following table.

How can I solve this problem

Options: ReplyQuote

Written By
SQL Vendor Sort
April 02, 2021 02:18PM
April 02, 2021 03:50PM
November 26, 2021 07:19AM
November 28, 2021 08:35PM
November 28, 2021 07:42PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.