Кейсы и задания для ассессмента

string(2664) "SELECT Rank = ROW_NUMBER() OVER (order by case when Orders.ServiceID=5 then Orders.CountComments else Orders.CountMarks end desc, case when Orders.ServiceID=5 then Orders.CountComments else Orders.CountMarks end desc, Orders.CountComments desc, Orders.PubDate) ,OrderTags.[OrderID] ,OrderTags.[TagID] ,TagClubGroupID ,OrderTop ,ServiceID ,LEFT(Orders.Ref,500) as Ref ,Orders.CityID ,Customers.CustomerID ,CountPositive ,CountNegative ,CountViews ,CountMarks ,CountComments ,Orders.Alias as OrderAlias ,PubDate ,EndDate ,Login ,FaceID ,TotalRating ,Picture ,Spetsnaz ,HrClub ,PRO ,Checked ,Customers.HRTop30 ,Top100 ,TarifID ,CustomerOrders ,CountMaterials ,GetRecommendations ,Education ,Clients ,Tasks ,Position ,CountActions ,CountArticles ,CountGoodComments ,CustomerLevelID ,Customers.Page404 FROM OrderTags join Tags on Tags.TagID = [OrderTags].TagID join Orders on OrderTags.OrderID = Orders.OrderID join Customers on Orders.CustomerID = Customers.CustomerID where OrderStatusID = 1 and TagClubGroupID = 355"