Aggregate Functions: SQL has some built-in functions and they are called as aggregate functions. SQL contains five built-in functions. They are: SUM – This function is used to add values from the particular column. Syntax: SELECT SUM(column_Name) FROM table_Name; COUNT – This is used to count the number of rows for the particular column. Syntax: SELECT COUNT(column_Name) FROM table_Name; MAX – This function is used to get the maximum value from the column. Syntax: SELECT MAX(column_Name) FROM table_Name; MIN – This function is used to get the minimum value from the column. Syntax: SELECT MIN(column_Name) FROM table_Name; AVG – This function is used to get the average of all the values from the column. Syntax: SELECT AVG(column_Name) FROM table_Name; DISTINCT Keyword: “DISTINCT” keyword is used to avoid redundant data (removing duplicate values) from a column. The syntax for “DISTINCT” keyword is as follows: Syntax: SELECT DISTINCT column_Name FROM table_Name; “NOT IN” Keyword: “NOT IN” keyword retrieves all the elements of the first table and the contents that are not matched in the second table.

Question

List the balance characteristics of the customers who have made purchases during the current invoice cycle—that is, for the customers who appear in the INVOICE table. The results of this query are shown in Figure P7.37.

Answer 1

Question

Chapter 7, Problem 41P

Program Plan Intro

Aggregate Functions:

SQL has some built-in functions and they are called as aggregate functions. SQL contains five built-in functions. They are:

SUM – This function is used to add values from the particular column.

Syntax: SELECT SUM(column_Name) FROM table_Name;

COUNT – This is used to count the number of rows for the particular column.

Syntax: SELECT COUNT(column_Name) FROM table_Name;

MAX – This function is used to get the maximum value from the column.

Syntax: SELECT MAX(column_Name) FROM table_Name;

MIN – This function is used to get the minimum value from the column.

Syntax: SELECT MIN(column_Name) FROM table_Name;

AVG – This function is used to get the average of all the values from the column.

Syntax: SELECT AVG(column_Name) FROM table_Name;

DISTINCT Keyword:“DISTINCT” keyword is used to avoid redundant data (removing duplicate values) from a column. The syntax for “DISTINCT” keyword is as follows:

Syntax:

SELECT DISTINCT column_Name FROM table_Name;

“NOT IN” Keyword: “NOT IN” keyword retrieves all the elements of the first table and the contents that are not matched in the second table.

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

List the balance characteristics of the customers who have made purchases during the current invoice cycle—that is, for the customers who appear in the INVOICE table. The results of this query are shown in Figure P7.37.

Show all name and phone numbers of students and the type of donation they received including any unmatched student.table name;StudentDonationVolunteer

7. List all customers who were referred to the bookstore by another customer. List eachcustomer’s last name and the number of the customer who made the referral.