Q8. Examine the description of the EMPLOYEES table:

NLS_DATE_FORMAT is set to DD-MON-YY.
Which query requires explicit data type conversion?
- (A). SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
- (B). SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
- (C). SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
- (D). SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
Xem thêm:

Mig - Law & Attorney Elementor Template Kit
Rexbiz Elementor Template Kit
Fumia- Startup Agency Template Kit
Amely Shopify Theme
Apparelix Mens Fashion Shopify Theme
Funnia - template kit digital agency service
Adaptable Notes Wordpress Theme
Dreative Elementor Template Kit
Apparelix Food Delivery Shopify Theme
Baum - Furniture Multipurpose Responsive Shopify Theme
Evtro - Conference Template Kit
Whoop Elementor Template Kit
Creativo - Creative Agency Elementor Template Kit
Vlog - Video Blog & Podcast WordPress Theme
Swarra - Podcast with Merchandise Store Elementor Template Kit