You have already asked 289 questions, most of them about SQL!
I'd suggest you to buy good book about SQL. Read it, read it again and read it every time before you ask a question. MSDN documentation is obligatory reading too!
Do you know what people think about such of lazy programmer?
As to your qustion... Have you tried to execute your query?
Please, do not answer. I know the answer: No, you don't! Because you'll know that this statement is wrong!
To get count of records:
select partid, product, COUNT(*) OVER(ORDER BY partid) CountOfRecordsInProductTable
More detalis at: COUNT (Transact-SQL) - SQL Server | Microsoft Docs