Table: texture_compression
Columns: fourcc
dx_10_name
description
alpha_premultiplied
compression_ratio
texture_type

Question: Which DX 10 Name that has a No Alpha premultiplied and a Description of explicit alpha?
SQL: SELECT "dx_10_name" FROM texture_compression WHERE "alpha_premultiplied" = 'no' AND "description" = 'explicit alpha'

Question: Which Compression ratio has a (none) DX 10 Name and a FOURCC of dxt4?
SQL: SELECT "compression_ratio" FROM texture_compression WHERE "dx_10_name" = '(none)' AND "fourcc" = 'dxt4'

Question: Which Alpha premultiplied has a 4:1 Compression ratio and a dxt3 FOURCC?
SQL: SELECT "alpha_premultiplied" FROM texture_compression WHERE "compression_ratio" = '4:1' AND "fourcc" = 'dxt3'