Consider the CUSTOMERS table having the following record

Q. Consider the CUSTOMERS table having the following records:

Table: CUSTOMERS

 

 
	 
ID
 
	 
NAME
 
	 
AGE
 
	 
ADDRESS
 
	 
SALARY
 
 
 
	 
1
 
	 
Ramesh
 
	 
32
 
	 
Ahmedabad
 
	 
2000.00
 
 
 
	 
2
 
	 
Khilan
 
	 
25
 
	 
Delhi
 
	 
1500.00
 
 
 
	 
3
 
	 
Kaushik
 
	 
23
 
	 
Kota
 
	 
2000.00
 
 
 
	 
4
 
	 
Chaitali
 
	 
25
 
	 
Mumbai
 
	 
6500.00
 
 
 
	 
5
 
	 
Hardik
 
	 
27
 
	 
Bhopal
 
	 
8500.00
 
 
 
	 
6
 
	 
Komal
 
	 
22
 
	 
Bengaluru
 
	 
4500.00
 
 
 
	 
7
 
	 
Muffy
 
	 
24
 
	 
Indore
 
	 
10000.00
 
 

(a) Write an SQL query to display all records in ascending order of name.

(b) Write an SQL query to display all records in descending order of name.

(c) Write an SQL query to display all records in ascending order of name and  descending order of age.

(d) Write an SQL query to display maximum salary.

(e) Write an SQL query to display minimum salary.

(f) Write an SQL query to display total number of records.

(g) Write an SQL query to display average salary.

(h) Write an SQL query to display total salary of all the persons.

(i) Write an SQL query to display names of those persons whose salary is greater than the average salary.

(j) Write an SQL query to display details of those persons whose age is less than the average age.

Answer :-

(a) Select * from Customer order by name ;
(b) Select * from Customer order by name Desc ;
(c) Select * from Customer order by name , age Desc ;
(d) Select max( Salary ) from Customer ;
(e) Select min( Salary ) from Customer ;
(f) Select count( * ) from Customer ;
(g) Select Avg( Salary ) from Customer ;
(h) Select Sum( Salary ) from Customer ;
(i) Select name from Customer where (Select avg ( Salary ) from Customer ) > Salary ;
(j) Select * from Customer where (Select avg ( age ) from Customer ) >  age ;