“SELECT” command: The “SELECT” command is used to retrieve data in a database . Syntax for selecting values from the table is as follows: SELECT STUDENT_ID FROM STUDENT; The given query is used to display each student ID from “STUDENT” table. “SUM” function: It is the one function of aggregate function. The “SUM” function is used to compute the total of the values in a column. Example: The example for “SUM” function is given below: SELECT SUM(MARK_CREDIT) FROM STUDENT; The above query is used to display the sum of all students mark credit from “STUDENT” table using “SUM” function. “GROUP BY” Clause: User can group the data using “GROUP BY” clause. This clause allows the user to group data on a specific column and then computes statistics when user preferred. Example: The example for “GROUP BY” clause is given below: SELECT CUSTOMER_NAME, SUM(AMOUNT) FROM CUSTOMERS GROUP BY CUSTOMER_NAME; The above query is used to list the customer name and the sum of amount using “GROUP BY” clause. “HAVING” Clause: The “HAVING” clause is used to restrict the groups that are included. This restriction does not apply to individual rows but relatively apply to groups. Example: The example for “HAVING” clause is given below: SELECT STUDENT_ID, NAME, AGE, ADDRESS, TOTAL_MARK FROM STUDENTS GROUP BY AGE HAVING COUNT(AGE) >= 10; The above query is used to display a record for a similar age count that would be more than or equal to “10”.

Question

Note:- Do correct answer get upvote Else downvoted

Answer 1

Question

Chapter 4, Problem 18CAT

Program Plan Intro

“SELECT” command:

The “SELECT” command is used to retrieve data in a database.

Syntax for selecting values from the table is as follows:

SELECT STUDENT_ID FROM STUDENT;

The given query is used to display each student ID from “STUDENT” table.

“SUM” function:

It is the one function of aggregate function.

The “SUM” function is used to compute the total of the values in a column.

Example:

The example for “SUM” function is given below:

SELECT SUM(MARK_CREDIT) FROM STUDENT;

The above query is used to display the sum of all students mark credit from “STUDENT” table using “SUM” function.

“GROUP BY” Clause:

User can group the data using “GROUP BY” clause.

This clause allows the user to group data on a specific column and then computes statistics when user preferred.

Example:

The example for “GROUP BY” clause is given below:

SELECT CUSTOMER_NAME, SUM(AMOUNT) FROM CUSTOMERS GROUP BY CUSTOMER_NAME;

The above query is used to list the customer name and the sum of amount using “GROUP BY” clause.

“HAVING” Clause:

The “HAVING” clause is used to restrict the groups that are included.

This restriction does not apply to individual rows but relatively apply to groups.

Example:

The example for “HAVING” clause is given below:

SELECT STUDENT_ID, NAME, AGE, ADDRESS, TOTAL_MARK FROM STUDENTS GROUP BY AGE HAVING COUNT(AGE) >= 10;

The above query is used to display a record for a similar age count that would be more than or equal to “10”.

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

Note:- Do correct answer get upvote Else downvoted

Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns. In addition, you must calculate the order total from the columns in the OrderItems table. Write a second SELECT statement that uses the first SELECT statement in its FROM clause. The main query should return two columns: the customer�s email address and the largest order for that customer. To do this, you can group the result set by the EmailAddress column.

the employee table have the following . ask user what is the employee_id and how much employee wants to contribute 2 substitutions variable from end user &emp_id &contribution_amount If employee salary is in between $1000-$3999 And if employee's contribution amount is less than $100 then company match $100 if employee's contribution amount is greater than 100 but less than $200 then company match $75 if employee's contribution amount is greater than $200 then company match $50 $4000-$6999 And if employee's contribution amount is less than $100 then company match $150 if employee's contribution amount is greater than 100 but less than $200 then company match $100 if employee's contribution amount is greater than $200 then company match $75 $7000-$12000And if employee's contribution amount is less than $100 then company match $200 if employee's contribution amount is greater than…