Task: Text to Code
Input (English): Step 1: find rows in Documents table whose Document_Type_Code equals BK.
Step 2: find each value of Document_ID the results of step 1 along with the number of the corresponding rows to each value
Output (English): SELECT Count ( * ) , Project_ID FROM Documents WHERE Document_Type_Code = "BK" GROUP BY Document_ID