0

SQL Vendor Join

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

27th Oct 2021, 7:50 AM
william
7 Respuestas
0
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;
27th Oct 2021, 11:30 AM
Anima Singh Dhabal
Anima Singh Dhabal - avatar
+ 1
Yeah but where are those tables william
27th Oct 2021, 8:11 AM
Anima Singh Dhabal
Anima Singh Dhabal - avatar
0
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.
27th Oct 2021, 7:52 AM
william
0
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 williamgates01@the23app.com
27th Oct 2021, 9:45 AM
william
0
william wait am trying to solve it..till then you remove your email id from here
27th Oct 2021, 10:14 AM
Anima Singh Dhabal
Anima Singh Dhabal - avatar
0
Ok Mr. Singh Please paste code in Sololearn as answer
27th Oct 2021, 10:29 AM
william
0
Thakyou Mr. Singh.
27th Oct 2021, 12:43 PM
william