Where can subqueries be used?（）

• A、field names in the SELECT statement 
• B、the FROM clause in the SELECT statement 
• C、the HAVING clause in the SELECT statement
• D、the GROUP BY clause in the SELECT statement 
• E、the WHERE clause in only the SELECT statement 
• F、the WHERE clause in SELECT as well as all DML statements