w3resource
SQL exercises

SQL Exercises: Find the number of customers who gets at least a gradation for his/her performance

SQL Aggregate Functions: Exercise-5 with Solution

Write a SQL statement find the number of customers who gets at least a gradation for his/her performance.

Sample table: customer


Sample Solution:

SELECT COUNT (ALL grade) 
FROM customer;

Output of the Query:

count
7

Explanation:

Syntax of find the number of customers who gets at least a gradation for his/her performance

Pictorial presentation:

Find the number of customers who gets at least a gradation for his/her performance

Query Visualization:

Duration:

Query visualization of Find the number of customers who gets at least a gradation for his/her performance - Duration

Rows:

Query visualization of Find the number of customers who gets at least a gradation for his/her performance - Rows

Cost:

Query visualization of Find the number of customers who gets at least a gradation for his/her performance - Cost

 

Practice Online


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a SQL statement to know how many customers have listed their names.
Next: Write a SQL statement to know the maximum purchase amount of all the orders.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming