How many wrestlers are recorded for the chamber that's method of elimination was pinned after being hit by a lead pipe? 
CREATE TABLE table_24628683_2 (wrestler VARCHAR, method_of_elimination VARCHAR)
SELECT COUNT(wrestler) FROM table_24628683_2 WHERE method_of_elimination = "Pinned after being hit by a lead pipe"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_24628683_2 (wrestler VARCHAR, method_of_elimination VARCHAR) Question: How many wrestlers are recorded for the chamber that's method of elimination was pinned after being hit by a lead pipe?  [/INST] SELECT COUNT(wrestler) FROM table_24628683_2 WHERE method_of_elimination = "Pinned after being hit by a lead pipe" </s>