Question

create a view vHW1_Q5 with columns (type, state, wage) showing the state that has the minimum wage and maximum wage. using mysql

Answer 1

Coding:

Create table Hw1_Q5(type varchar(20),state varchar(20), wage int);
insert into Hw1_Q5 values('Software','Open',30);
insert into Hw1_Q5 values('Hardware','Close',130);
insert into Hw1_Q5 values('Panel','Open',330);
insert into Hw1_Q5 values('Port','Close',730);
Select * From Hw1_Q5;

Create table vHw1_Q5 as Select min(wage) as "Minimum Wage",max(wage)'Maximum Wage' From Hw1_Q5;

Select * From vHw1_Q5;

if you still have any Problem regarding this question please comment and if you like my code please appreciate me by thumbs up thank you.........