Question

1 Write an SQL query to display details of those persons whose age is less than average age.
consider the CUSTOMERS table having the following records:
NAME
ADDRESS SALARY
Ramesh
Ahmedabad 2000.00
Khian
1500.00
3 Kaushik
Kata
2000.00
Mumbai
5
Bhopal
8500.00
Komal
MP
Muty
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, descending order of age
id) Write an SOL query to display maximum salary,
(e) Write an Sal query to display minimum salary
(1) Write an SQL query to display total number of records,
le) Write an Sal query to display average salary.
th) Write an Sal query to display total salary of all the persons,
ERA PATEL​