SQL Challenge Your table: maintable, E916A MySQL version: 8.0.23 In this MySQL challenge, your query should return the v

[answerhappygod]

Sql Challenge Your Table Maintable E916a Mysql Version 8 0 23 In This Mysql Challenge Your Query Should Return The V 1 (48.94 KiB) Viewed 80 times

SQL Challenge Your table: maintable, E916A MySQL version: 8.0.23 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 Group ID column. The final query should only print out the GroupID, Company Name, and final count of all rows that are grouped into each company name under a column titled Count. The output table should be then sorted by the Count column and then sorted by GroupID SO that a higher number appears first. Your output should look like the following table. |GroupID 27 5 36 35 6 40 39 Company Name 1 Count Machinx WaterBus Enterprise | Johnson and Sons Shipping & Co. Alloy LLC FireConsulting News Corp. 12 6 Browse Resources powered by Google Search for any help or documentation you might need for this problem. For example: array indexing, Ruby hash tables, etc. 23456849 7
Run Code View Table Your output is incorrect. GroupID Year Vendor ID FirstName LastName 35 35 35 36 36 39 39 39 39 39 39 40 40 40 40 in 6 2018 102 6 2018 27 2018 2018 102 2018 2018 1988 2018 2018 102 2018 1988 2019 48 2019 1988 2018 650 2018 1988 102 650 2012 2019 102 2012 2019 650 2009 12 2019 1988 2012 478 6 2012 478 102 1988 478 478 Submit 12 Daniel Manager Sully Manager Arnold Sully Manager Daniel Knolle Manager Arnold Sully Manager Knolle Manager Manager Manager Roberts Manager Sully Manager Dial Arnold Daniel Daniel Lisa Lisa Roberts Arnold Mary Daniel Daniel Lisa Arnold Arnold Dennis Dennis Knolle Larry Larry Mary Knolle S Job Knolle Manager Knolle Manager Roberts Manager Sully Manager Sully Manager 5 Contractor Weis Manager Dial Contractor Contractor Weis Contractor Manager ExternalID Region West 39765 48587 48507 8219 48507 8219 39765 1860 1860 8219 39765 1860 39765 48587 5397 Central 48587 24122 10272 4219 10272 West 1860 East West West West West West West East East West West West West North North North North East