Select __________ from instructor where dept name= 'Comp. Sci.';Which of the fo

Question

Select __________ from instructor where dept name= 'Comp. Sci.';Which of the following should be used to find the mean of the salary ?

Options:

A . Mean(salary)

B . Avg(salary)

C . Sum(salary)

D . Count(salary)

Answer: Option B

Avg(salary)Avg() is used to find the mean of the values.

Was this answer helpful ?

Next Question

More Questions on This Topic :

Question 1. All aggregate functions except _____ ignore null values in their input collection. ....

Question 2. Aggregate functions are functions that take a ___________ as input and return a single value. ....

Question 3. Select count (____ ID)from teacheswhere semester = 'Spring' and year = 2010;If we do want to eliminate duplicates, we u....eliminate duplicates, we use the keyword ______in the aggregate expression.

Question 4. A Boolean data type that can take values true, false, and________ . ....

Question 5. We can test for the nonexistence of tuples in a subquery by using the _____ construct. ....

Question 6. The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ....The ____ connective tests for the absence of set membership.

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI

Tabulation - Test Paper 2 Data Interpretation Reasoning & DI

Test Paper 1 Direction Sense Test Reasoning & DI

ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0

GFM Combined 1 Free Revision Test SAIL JO E-0