SQL Server Greatest n per Group Query: Customer Information with Latest Date, Sql Server

Language: Layout:

create table Customer (Id int, name varchar(32), account varchar(32), active varchar(5))
insert into Customer values
 (1,'Bob','ABC','True')
,(2,'Jenny','BED','True')
,(3,'Tony','POT','False')
,(4,'David','DON','False')
create table [Order] (OrderId int, CustomerId int, OrderDate date, Status int)
insert into [Order] values
 (1,2,'2016-04-01',3)
,(2,2,'2016-09-05',7)
,(3,2,'2017-02-20',5)
,(4,3,'2015-02-20',8)
,(5,4,'2017-04-16',3)

select top 1 with ties
    c.Id, c.[Name], c.Account, c.Active, o.Status, OrderDate = convert(char(10),o.OrderDate,120)
from Customer as c
  left join [Order] o
    on c.Id = o.CustomerId
   and o.Status in (3,7)
where c.Active is not null
order by row_number() over (partition by c.Id order by o.OrderDate desc)

select 
  c.Id, c.[Name], c.Account, c.Active, o.Status, OrderDate = convert(char(10),o.OrderDate,120)
from Customer as c
  outer apply (
    select top 1
      i.Status, i.OrderDate
    from [Order] i
    where i.CustomerId = c.Id
      and i.Status in (3,7)
    order by i.OrderDate desc
  ) as o
  
Select Distinct c.Id, c.[Name], c.Account, c.Active, o.Status, LatestDate = convert(char(10),LatestDate,120)
From Customer as c
  Left Outer Join (
      Select CustomerId, Max(OrderDate) as LatestDate 
      From [Order] i
      where i.Status in (3,7)
      Group By CustomerId
      ) LatestDates On c.Id = LatestDates.CustomerId
  Left Join [Order] o 
    on LatestDates.CustomerId = o.CustomerId 
   and LatestDates.LatestDate = o.OrderDate
Where c.Active is not null

View schema
Execution time: 0,04 sec, rows selected: 12, rows affected: 9, absolute service time: 0,2 sec

SQL Server Greatest n per Group Query: Customer Information with Lates...