SQL Subquery - Dofactory

PHOTO EMBED

Fri Aug 13 2021 20:14:09 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira #sql

SELECT CompanyName, 
       ProductCount = (SELECT COUNT(P.id)
                         FROM [Product] P
                        WHERE P.SupplierId = S.Id)
  FROM Supplier S
content_copyCOPY

https://www.dofactory.com/sql/subquery