WHICH AGE GROUP PEOPLE IS GETTING HIGHEST SALARY

/* WHICH AGE GROUP PEOPLE IS GETTING HIGHEST SALARY */

-- MAXIMUM SALARY
-- MINIMUM SALARY

/* REPLACE MIN() FUNCTION WITH MAX() YOU WILL GET MAXIMUM SALARY OR ELSE YOU WILL GET MINIMUM SALARY */


CREATE DATABASE MY_PRACTICE

GO

USE MY_PRACTICE

GO

CREATE TABLE [dbo].[persons](
 [id] [int] IDENTITY(1,1) PRIMARY KEY,
 [Name] [char](20) NULL,
 [age] [int] NULL,
 [salary] [float] NULL)

 GO

 INSERT INTO persons VALUES ('sagar',28,5000),('shirish',25,2000),('raj',32,4000),('AMBI',27,8000)
,('SURESH',30,6000),('vidya',22,1500)

GO

SELECT * FROM persons


GO

SELECT ID,NAME,AGE,MIN(salary)as MAX_SALARY FROM persons
WHERE salary = (SELECT MIN(salary) FROM persons WHERE age BETWEEN 20 AND 25)
GROUP BY id,Name,age

UNION ALL

SELECT ID,NAME,AGE,MIN(salary)as MAX_SALARY FROM persons
WHERE salary = (SELECT MIN(salary) FROM persons WHERE age BETWEEN 26 AND 30)
GROUP BY id,Name,age

UNION ALL

SELECT ID,NAME,AGE,MIN(salary)as MAX_SALARY FROM persons
WHERE salary = (SELECT MIN(salary) FROM persons WHERE age BETWEEN 31 AND 35)
GROUP BY id,Name,age