Which company in the oil and gas industry has assets (billion $) under 235.45, sales (billion $) larger than 159.29 and brings in profits (billion $) of 19.28?
CREATE TABLE "2010_list" (
  "rank" real,
  "company" text,
  "headquarters" text,
  "industry" text,
  "sales_billion" real,
  "profits_billion" real,
  "assets_billion" real,
  "market_value_billion" real
);
SELECT "company" FROM "2010_list" WHERE "assets_billion"<235.45 AND "sales_billion">159.29 AND "industry"='oil and gas' AND "profits_billion"=19.28;