1Z0-061 · Question #297
View the Exhibit and examine the structure and data in the INVOICE table. Which two SQL statements would execute successfully? (Choose two.)
The correct answer is B. SELECT MAX(inv_date), MIN(cust_id) D. SELECT AVG( inv_date - SYSDATE), AVG(inv_amt). Using the AVG and SUM Functions You can use the AVG, SUM, MIN, and MAX functions against the columns that can store numeric data. The example in the slide displays the average, highest, lowest, and sum of monthly salaries for all sales representatives Using the MIN and MAX…
Question
View the Exhibit and examine the structure and data in the INVOICE table. Which two SQL statements would execute successfully? (Choose two.)
Options
- ASELECT AVG(inv_date )
- BSELECT MAX(inv_date), MIN(cust_id)
- CSELECT MAX(AVG(SYSDATE - inv_date))
- DSELECT AVG( inv_date - SYSDATE), AVG(inv_amt)
How the community answered
(28 responses)- A18% (5)
- B71% (20)
- C11% (3)
Explanation
Using the AVG and SUM Functions You can use the AVG, SUM, MIN, and MAX functions against the columns that can store numeric data. The example in the slide displays the average, highest, lowest, and sum of monthly salaries for all sales representatives Using the MIN and MAX Functions You can use the MAX and MIN functions for numeric, character, and date data types. The example in the slide displays the most junior and most senior employees.
Topics
Community Discussion
No community discussion yet for this question.