Which Compression ratio has a (none) DX 10 Name and a FOURCC of dxt4?
CREATE TABLE table_name_57 (compression_ratio VARCHAR, dx_10_name VARCHAR, fourcc VARCHAR)
SELECT compression_ratio FROM table_name_57 WHERE dx_10_name = "(none)" AND fourcc = "dxt4"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_57 (compression_ratio VARCHAR, dx_10_name VARCHAR, fourcc VARCHAR) Question: Which Compression ratio has a (none) DX 10 Name and a FOURCC of dxt4? [/INST] SELECT compression_ratio FROM table_name_57 WHERE dx_10_name = "(none)" AND fourcc = "dxt4" </s>