SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Delivery ( OrderId INT IDENTITY(1, 1), CourierId INT ); CREATE TABLE Courier_info ( CourierId INT IDENTITY(1, 1), Name VARCHAR(64), Surname VARCHAR(64), Phone VARCHAR(64) ); INSERT INTO Courier_info (Name) VALUES ('Vitaly'); SELECT COALESCE(Count(Delivery.OrderId)), Delivery.CourierId, Name, Surname, Phone FROM Courier_info LEFT JOIN Delivery ON Delivery.CourierId = Courier_info.CourierId GROUP BY Delivery.CourierId, Name, Surname, Phone ;