What's the Cardinalatial Title has the Elevated of December 18, 1182, the Place of birth of Lucca, and the Electo rof Pandolfo?
CREATE TABLE table_name_40 (cardinalatial_title VARCHAR, elector VARCHAR, elevated VARCHAR, place_of_birth VARCHAR)
SELECT cardinalatial_title FROM table_name_40 WHERE elevated = "december 18, 1182" AND place_of_birth = "lucca" AND elector = "pandolfo"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (cardinalatial_title VARCHAR, elector VARCHAR, elevated VARCHAR, place_of_birth VARCHAR) Question: What's the Cardinalatial Title has the Elevated of December 18, 1182, the Place of birth of Lucca, and the Electo rof Pandolfo? [/INST] SELECT cardinalatial_title FROM table_name_40 WHERE elevated = "december 18, 1182" AND place_of_birth = "lucca" AND elector = "pandolfo" </s>