CREATE TABLE student (
  sid INTEGER PRIMARY KEY,
  name VARCHAR(30) NOT NULL,
  gender CHAR(1) NOT NULL,
  deptid INTEGER NOT null,
  salary INTEGER NOT null
);
-- create a department table
create table department(
deptid INTEGER PRIMARY key,
deptname VARCHAR(10) NOT null
);
-- insert some student values
INSERT INTO student VALUES
(1, 'adnan', 'M',1,5000),
(2, 'turjoy', 'F',2,6000),
(3, 'helal', 'F',2,2000),
(4, 'shovon', 'F',1,9000),
(5, 'rajib', 'M',1,8000),
(6, 'rinku', 'M',3,15000),
(7, 'alif', 'F',3,17000);
-- insert some student values
insert into department values(1,"CSE"),(2,"EEE"),(3,"CIVIL");

select * from student
where salary in (
select max(salary) from student
);

select * from student
where salary in (
select max(salary) from student
group by deptid
);