Subquery in SELECT clause

SELECT
  Id, 
  FName, 
  LName,
  (SELECT COUNT(*) FROM Cars WHERE Cars.CustomerId = Customers.Id) AS NumberOfCars
FROM Customers

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents