Adding DDL & DML commands.
-----Create Table-------
create table student(name varchar(50),sid varchar(50),marks int)
-------insert records--------
insert into student values('a','x',75)
insert into student values('a','y',75)
insert into student values('a','z',80)
insert into student values('b','x',90)
insert into student values('b','y',91)
insert into student values('b','z',75)
------create table-------
create table gender_pers(eid int,ename varchar(50),gender varchar(50))
------insert records-----
insert into gender_pers values(1,'John','Male')
insert into gender_pers values(2,'Smith','Male')
insert into gender_pers values(3,'Anna','Female')
insert into gender_pers values(4,'Sara','Female')
insert into gender_pers values(5,'Jeneth','Female')
insert into gender_pers values(6,'Adrew','Male')
insert into gender_pers values(7,'Warren','Male')
insert into gender_pers values(8,'James','Male')
------create table-------
create table proportion(Name varchar(50),Price int)
------insert records-----
insert into proportion values('Amit',200)
insert into proportion values('Sumit',100)
insert into proportion values('Anil',300)
insert into proportion values('Anna',200)
17 сен 2024
