What is the total net profit when earnings per share is 27.4, and profit/loss befor tax was smaller than 194.6 million?
CREATE TABLE table_name_75 (net_profit__ INTEGER, earnings_per_share__p_ VARCHAR, profit__loss__before_tax__£m_ VARCHAR)
SELECT SUM(net_profit__) AS £m_ FROM table_name_75 WHERE earnings_per_share__p_ = 27.4 AND profit__loss__before_tax__£m_ < 194.6
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_75 (net_profit__ INTEGER, earnings_per_share__p_ VARCHAR, profit__loss__before_tax__£m_ VARCHAR) Question: What is the total net profit when earnings per share is 27.4, and profit/loss befor tax was smaller than 194.6 million? [/INST] SELECT SUM(net_profit__) AS £m_ FROM table_name_75 WHERE earnings_per_share__p_ = 27.4 AND profit__loss__before_tax__£m_ < 194.6 </s>