题解 | #列出供应商及其可供产品的数量#
列出供应商及其可供产品的数量
http://www.nowcoder.com/practice/17f22851cf204019b51a36761a3afc79
SELECT a.vend_id,COUNT(b.prod_id) FROM Vendors a LEFT JOIN Products b ON a.vend_id=b.vend_id GROUP BY a.vend_id ORDER BY a.vend_id ASC;
列出供应商及其可供产品的数量
http://www.nowcoder.com/practice/17f22851cf204019b51a36761a3afc79
SELECT a.vend_id,COUNT(b.prod_id) FROM Vendors a LEFT JOIN Products b ON a.vend_id=b.vend_id GROUP BY a.vend_id ORDER BY a.vend_id ASC;
相关推荐
程序员小白条:简历写的有点太多了,一般两页是实习经历比较多的情况下,要么自己有一些有影响力的开源项目,如果你走软件,硬件没必要实习,学校安排总是没区分度的,央国企最好有中大厂实习,另外学历比较重要,不是都要求硕士的,技术会比互联网要求低一些