select COUNT(*) FROM dbo.condition WHERE (datepart(year,datecondition)=2018 AND       
datepart(month,datecondition)=10) AND codpribytiya = 1 and codpunkta = 1

SELECT * FROM clients WHERE codclient IN 
( SELECT codclient FROM dbo.offer WHERE offernumber NOT IN 
(SELECT offernumber FROM dbo.condition WHERE  (datepart(year,datecondition)=2018 )))

datepart(year,datecondition)=2018

WITH CTE AS
(
  SELECT C.CODPUNKTA,COUNT(*)CNTT FROM dbo.condition C
   WHERE CAST(C.datecondition AS DATE)>='20181001' 
     AND CAST(C.datecondition AS DATE)<'20181101'
   GROUP BY C.CODPUNKTA
)
SELECT TOP 3 CT.CODPUNKTA,CT.CNTT
 FROM CTE AS CT
  ORDER BY C.CNTT DESC

SELECT TOP 3 C.CODPUNKTA,COUNT(*)CNTT FROM dbo.condition C
   WHERE CAST(C.datecondition AS DATE)>='20181001' 
     AND CAST(C.datecondition AS DATE)<'20181101'
   GROUP BY C.CODPUNKTA
 ORDER BY 2 DESC

SELECT * 
FROM clients CL
WHERE NOT EXISTS
 (
SELECT NULL
FROM dbo.offer ff INNER JOIN dbo.condition cn ON FF.offernumber = CN.offernumber
WHERE FF.codclient  = CL.codclient 
 AND datepart(year,CN.datecondition)=2018
)