SQL Vendor Join

Question

Unable to bring output using my sql code.

SELECT Distinct maintable_9GFV2.GroupID, cb_vendorinformation.CompanyName From maintable_9GFV2 INNER JOIN cb_vendorinformation ON maintable_9GFV2.GroupID = cb_vendorinformation.GroupID;

https://coderbyte.com/sl-candidate?promo=rhealth-jaswt:backend-develop-wwurzdwi5m

Answer 1

william

SELECT m.GroupID,c.CompanyName,Count(*) as count_

FROM maintable_Y3J5N m INNER JOIN cb_vendorinformation c ON m.GroupID=c.GroupID

Group By m.GroupId,c.CompanyName ORDER BY count_,m.GroupID,c.CompanyName desc;

Answer 2

Yeah but where are those tables william

Answer 3

Description

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 only print out the GroupID, CompanyName, 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.

Answer 4

https://coderbyte.com/sl-candidate?promo=rhealth-jaswt:backend-develop-wwurzdwi5m

Please go to the above link using desktop mode
Enter name and email address.
Name : WILLIAM
Email [e-mail]

Answer 5

william wait am trying to solve it..till then you remove your email id from here

Answer 6

Ok Mr. Singh
Please paste code in Sololearn as answer

Answer 7

Thakyou Mr. Singh.