Qual empresa tem um valor de mercado superior a 1, Ativos (US$ bilhões) menores que 10,7, um Rank menor que 10 e receita (US$ bilhões) de 9,3?
CREATE TABLE table_name_41 (company VARCHAR, revenues__us$_billion_ VARCHAR, rank VARCHAR, market_value__us$_billion_ VARCHAR, assets__us$_billion_ VARCHAR)
SELECT company FROM table_name_41 WHERE market_value__us$_billion_ > 1 AND assets__us$_billion_ < 10.7 AND rank < 10 AND revenues__us$_billion_ = 9.3