テーブルORDER_ITEMSには、データ型NUMBERの列ORDER_ID、UNIT_PRICE、QUANTITYが含まれています。 次のSQLステートメントを調べます。 ステートメント1: SELECT MAX(unit_price * Quantity) "Maximum Order" FROM order_items; ステートメント2: SELECT MAX(unit_price * Quantity) "Maximum Order" FROM order_items GROUP BY order_id; どちらが正しいですか?
正解:A,E
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj27781.html The Expression can contain multiple column references or expressions, but it cannot contain another aggregate or subquery. It must evaluate to a built-in data type. You can therefore call methods that evaluate to built-in data types. (For example, a method that returns a java.lang.Integer or int evaluates to an INTEGER.) If an expression evaluates to NULL, the aggregate skips that value.