Copy/Paste following commands in mysql workbench for creating table and inserting data in it
create database if not exists tg117 ;
use tg117 ;drop table employee;create table employee(eid int,ename varchar(30), monthly_salary float);
insert into employee(eid,ename,monthly_salary) values
(1,'Mahendra Bahubali',35000),
(2,'Fulchand Tripathi',15000),
(3,'Ranchod Das Chanchad',45000),
(4,'Ganesh Gaitonde',7000),
(5,'Ibu Hatela',9000),
(6,'Saiman Says',1000000);
select * from employee ;
Conditions to be applied :
Expected Output :
