“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. “COUNT” function: It is the one function of aggregate function. The “COUNT” function is used to compute the number of rows in a table. Example: The example for “COUNT” function is given below: SELECT COUNT() FROM STUDENT WHERE MARK_CREDIT >= 90; The above query is used to display the number of students whose mark credit is greater or equal to “90” by using “COUNT” function. From the given query, the asterisk () represent any column. User can also count the number of rows in a query by selecting a particular column instead of using the asterisk. The below example is as follows SELECT COUNT(STUDENT_ID) FROM STUDENT WHERE MARK_CREDIT >= 90;

Question

Want to see the full answer?

Answer 1

Question

Chapter 4, Problem 14TD

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.

“COUNT” function:

It is the one function of aggregate function.

The “COUNT” function is used to compute the number of rows in a table.

Example:

The example for “COUNT” function is given below:

SELECT COUNT() FROM STUDENT WHERE MARK_CREDIT >= 90;

The above query is used to display the number of students whose mark credit is greater or equal to “90” by using “COUNT” function.

From the given query, the asterisk () represent any column.

User can also count the number of rows in a query by selecting a particular column instead of using the asterisk.

The below example is as follows
SELECT COUNT(STUDENT_ID) FROM STUDENT WHERE MARK_CREDIT >= 90;

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

If a new entity Order_Details is introduced, will it be a strong entity or weak entity? If it is a weak entity, then mention its type (ID or Non-ID, also Justify why)?

Which one of the 4 Entities mention in the diagram can have a recursive relationship? Order, Product, store, customer.

Inheritance & Polymorphism (Ch11) There are 6 classes including Person, Student, Employee, Faculty, and Staff. 4. Problem Description: • • Design a class named Person and its two subclasses named student and Employee. • Make Faculty and Staff subclasses of Employee. • A person has a name, address, phone number, and e-mail address. • • • A person has a class status (freshman, sophomore, junior and senior). Define the status as a constant. An employee has an office, salary, and date hired. A faculty member has office hours and a rank. A staff member has a title. Override the toString() method in each class to display the class name and the person's name. 4-1. Explain on how you would code this program. (1 point) 4-2. Implement the program. (2 point) 4-3. Explain your code. (2 point)