The AVG function in SQL is used for:Finding the difference between the highest and lowest values.Calculating the average of all values in a numeric column or within a group.Duplicating all rows in a table.Selecting rows based on a specific pattern.

Which SQL function is used to calculate the average value of a numeric column?OptionsMAX()SUM()COUNT()AVG()

6. Computes the average value of a numeric column, offering insights into the central tendency or typical value in a dataset.A. AVGB. EQLC. SUMD. TOTAL5. SQL keyword that aggregates numeric values in a column, providing a total efficient analysis of numerical data.A. AVGB. EQLC. SUMD. TOTAL1.  The SQL ______ keyword is used in conjunction with the SELECT statement to fetch unique records from a table.A. DISTINCTB. UNIQUEC. AVGD. SELECT8. It is a logical operator used to combine multiple conditions in a WHERE clause. The result is true if at least one of the conditions is true.A. BETWEENB. ORC. LOGICD. AND2.  We use the _______ keyword with the SELECT statement when there is a need to avoid duplicate values present in any specific columns/tables.A. LIMITB. DISTINCTC. AVGD. SELECT4. It is an aggregate function in SQL used to ____ the number of rows that meet a specified condition or the total number of rows in a table.A. LIKEB. LIMITC. COUNTD. SELECT10. It is used as a database query language to express questions asked against databases.A. BETWEENB. ORC. LOGICD. AND9. It is a comparison operator used to filter results based on a range of values. It is often used with numerical or date values.A. BETWEENB. ORC. LOGICD. AND3.  It is used in an SQL query to restrict the number of rows returned by the query result.A. LIKEB. LIMITC. COUNTD. SELECT7. It is a logical operator used to combine multiple conditions in a WHERE clause. The result is true only if all the conditions are true.A. BETWEENB. ORC. LOGICD. AND

Which SQL function is used to find the number of rows in a table?OptionsMAX()SUM()COUNT()AVG()

Which SQL function is used to find the highest value in a column?OptionsMIN()AVG()SUM()MAX()

What function in SQL returns the average value of a numeric column?