Getting an error while running this tsql code : I am getting errors when I write this code. How can I fix it?
It says the error is on 'in'
    CREATE PROC spPracticum
    (
           @MaxCountry As VARCHAR,
    	   @MinCountry As VARCHAR
    )
    
    As
    
    SELECT [Country]
          ,[Year]
          ,[Subscribers]
          ,c.[name]
    	  
      FROM [dbo].[cell phone subscribers] as s
      join [dbo].[countries] as c on s.[Country] = c.[country-code]
      WHERE @MinCountry <= Country AND @MaxCountry >= Country IN (SELECT max(Subscribers) from [dbo].[cell phone subscribers] )
      ORDER by Year