create table party
(
partyid number primary key,
partydesc varchar2(20)
);
create table candidate
(
lname varchar(40) not null,
fname varchar(20) not null,
address varchar(20),
salary number,
dob date,
partyid number references party
);
GroupUnion 1) Display the name and the corresponding description based on the candidates salary (Use union and be e types) Order Honest Not so honest 80000 50000 >50000 and100000 >100000 2) Display the name and the corresponding description based on the candidates lain case statement in chapter 50000 >50000 and 100000 Honest Not so honest >100000
OR
OR