Table: greek_companies
Columns: rank
company
revenues_us_billion
profit_us_billion
assets_us_billion
market_value_us_billion

Question: What are the smallest assets with a Company of piraeus bank, and a Revenue (US$ billion) smaller than 3.9?
SQL: SELECT MIN("assets_us_billion") FROM greek_companies WHERE "company" = 'piraeus bank' AND "revenues_us_billion" < 3.9

Question: What is the average market value with a revenue greater than 6.2, a Company of national bank of greece, and a Rank smaller than 1?
SQL: SELECT AVG("market_value_us_billion") FROM greek_companies WHERE "revenues_us_billion" > 6.2 AND "company" = 'national bank of greece' AND "rank" < 1

Question: Which company has a market value greater than 1, Assets (US$ billion) smaller than 10.7, a Rank smaller than 10, and revenue (US$ billion) of 9.3?
SQL: SELECT "company" FROM greek_companies WHERE "market_value_us_billion" > 1 AND "assets_us_billion" < 10.7 AND "rank" < 10 AND "revenues_us_billion" = 9.3