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
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;
+ 1
Yeah but where are those tables william
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.
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
0
william wait am trying to solve it..till then you remove your email id from here
0
Ok Mr. Singh
Please paste code in Sololearn as answer
0
Thakyou Mr. Singh.