SQL Basics: Simple JOIN with COU
2019-05-13 本文已影响0人
是不及呀
| * | * |
|---|---|
| 链接 | SQL Basics: Simple JOIN with COUNT |
| 难度 | 7kyu |
| 状态 | √ |
| 日期 | 2019-5-13 |
题意
题解1
select people.id , people.name , count(toys.id) as toy_count
from people
left join toys
on people.id = toys.people_id
group by people.id
