how to add selected strike here to add another table <strike><u>select * from category_list</u></strike>

WITH cte AS 
(SELECT *, ROW_NUMBER() 
OVER (PARTITION BY list_id ORDER BY list_id DESC) AS rn FROM Products WHERE CategoryID in (select * from category_list)SELECT * FROM cte WHERE rn = 1 and category='couple'  order by cartid;