What were the investment earnings in a year when total revenue was $21,779,618?
CREATE TABLE table_name_23 (investment_earnings VARCHAR, total_revenue VARCHAR)
SELECT investment_earnings FROM table_name_23 WHERE total_revenue = "21,779,618"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (investment_earnings VARCHAR, total_revenue VARCHAR) Question: What were the investment earnings in a year when total revenue was $21,779,618? [/INST] SELECT investment_earnings FROM table_name_23 WHERE total_revenue = "21,779,618" </s>