eXtra_CustomerStatus_seed

main.sql

insert into CustomerStatus (CustomerId, CreationDate, CompletedRequestsCount, OperationSystemType, DeviceId, Registered,
                            ModifiedDate)
select distinct cus.Id                   as CustomerId,
                cus.CreationDate         as CreationDate,
                (
                    select Count(prs1.Id)
                    from ServiceRequests as prs1
                    where prs1.CustomerId = cus.Id AND prs1.Status = 2
                )
                                         as CompletedRequestsCount,
--       If not registered in the db for any reason we will assume it is android
                ISNULL(logs.OSTypeId, 1) as OperationSystemType,
                logs.MobileSerialNumber  as DeviceId,
                1,
                NULL

from Customers as cus
         left outer join Logs as logs on logs.CustomerId = cus.Id;