create table emp ( eid number(7), fname char(20), lname char(20), salary number, primary key (eid) ); insert into emp values (1111111, 'ali', 'ahmed', 3500); insert into emp values(2222222, 'asma', 'dani', 2000); insert into emp values(3333333, 'hassan', 'ali', 4500); insert into emp values(4444444, 'khaled', 'shaalan',6000); insert into emp values(5555555, 'farhad', 'kokol', 7500); insert into emp values(6666666, 'amir', 'sheikh', 10000); insert into emp values(7777777, 'rahul', 'kolap', 11000); insert into emp values(8888888, 'halim', 'ziaey', 21000); insert into emp values(9999999, 'henna', 'bubaker', 30000); THIS IS SECOND TABLE : create table students ( sid number, fname char(20), lname char(20), avg number, age number, primary key (sid) ); insert into students values (1111111, 'ali', 'ahmed', 76, 21); insert into students values(2222222, 'asma', 'dani', 89, 20); insert into students values(3333333, 'hassan', 'ali', 67, 23); insert into students values(4444444, 'khaled', 'shaalan',87, 24); insert into students values(5555555, 'farhad', 'kokol', 82, 19); insert into students values(6666666, 'amir', 'sheikh', 56, 18); insert into students values(7777777, 'rahul', 'kolap', 81, 22); insert into students values(8888888, 'halim', 'ziaey', 97, 21); insert into students values(9999999, 'henna', 'bubaker', 45, 18); NOW Write a program to get all male students and add 10% to their average if the average is 80 or above and 2% if the average is less than 80.
SQL:
THIS IS FIRST TABLE :
create table emp (
eid number(7),
fname char(20),
lname char(20),
salary number,
primary key (eid)
);
insert into emp values (1111111, 'ali', 'ahmed', 3500);
insert into emp values(2222222, 'asma', 'dani', 2000);
insert into emp values(3333333, 'hassan', 'ali', 4500);
insert into emp values(4444444, 'khaled', 'shaalan',6000);
insert into emp values(5555555, 'farhad', 'kokol', 7500);
insert into emp values(6666666, 'amir', 'sheikh', 10000);
insert into emp values(7777777, 'rahul', 'kolap', 11000);
insert into emp values(8888888, 'halim', 'ziaey', 21000);
insert into emp values(9999999, 'henna', 'bubaker', 30000);
THIS IS SECOND TABLE :
create table students (
sid number,
fname char(20),
lname char(20),
avg number,
age number,
primary key (sid)
);
insert into students values (1111111, 'ali', 'ahmed', 76, 21);
insert into students values(2222222, 'asma', 'dani', 89, 20);
insert into students values(3333333, 'hassan', 'ali', 67, 23);
insert into students values(4444444, 'khaled', 'shaalan',87, 24);
insert into students values(5555555, 'farhad', 'kokol', 82, 19);
insert into students values(6666666, 'amir', 'sheikh', 56, 18);
insert into students values(7777777, 'rahul', 'kolap', 81, 22);
insert into students values(8888888, 'halim', 'ziaey', 97, 21);
insert into students values(9999999, 'henna', 'bubaker', 45, 18);
NOW
Write a program to get all male students and add 10% to their average if the average is 80 or above and 2% if the average is less than 80.
Step by step
Solved in 2 steps with 4 images
