What are the smallest assets with a Company of piraeus bank, and a Revenue (US$ billion) smaller than 3.9?
CREATE TABLE table_name_16 (assets__us INTEGER, company VARCHAR, revenues__us$_billion_ VARCHAR)
SELECT MIN(assets__us) AS $_billion_ FROM table_name_16 WHERE company = "piraeus bank" AND revenues__us$_billion_ < 3.9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_16 (assets__us INTEGER, company VARCHAR, revenues__us$_billion_ VARCHAR) Question: What are the smallest assets with a Company of piraeus bank, and a Revenue (US$ billion) smaller than 3.9? [/INST] SELECT MIN(assets__us) AS $_billion_ FROM table_name_16 WHERE company = "piraeus bank" AND revenues__us$_billion_ < 3.9 </s>