Vedant Internet Cafe

RB Vlogs 24 months ago

create table emp_details(emp_id char(15),emp_name char(15),emp_desg char(15),sal_2018 int,sal_2022 int,department char(15));
insert into emp_details values("00A1","Samir.A","G.Manager",75000,95000,"Computer");
insert into emp_details values("00A2","Rohit.M","Supervisor",35000,55000,"Mecanical");
insert into emp_details values("00A3","Rishi.K","Worker",20000,27000,"Computer");
insert into emp_details values("00A4","Romil.A","worker",15000,20000,"Mecanical");
insert into emp_details values("00A5","Simran.H","Asst.Manager",50000,55000,"Electrical");
select * from emp_details;
select emp_name,emp_desg,sal_2018 from emp_details order by emp_id desc;
select department,count(*) from emp_details group by department;
select emp_name,sal_2022 from emp_details where emp_name like"R%";
select max(sal_2022) from emp_details;
select substr(emp_name,1,5) from emp_details;

create table teacher (tid int,name char(10),age int,department char(15),dateofjoin int,salary int,gender char(10));
insert into teacher values(1,'Jugal',34,'cs',10/01/17,12000,'m');
insert into teacher values(2,'Sharmila',31,'history',24/03/08,20000,'f');
insert into teacher values(3,'Sandeep',32,'maths',12/12/16,30000,'m');
insert into teacher values(4,'Sangeeta',35,'history',01/07/15,40000,'f');
insert into teacher values(5,'Rakesh',42,'maths',5/09/07,25000,'m');
insert into teacher values(6,'Shyam',50,'history',27/06/08,30000,'m');
insert into teacher values(7,'Shivom',44,'cs',25/02/17,21000,'m');
insert into teacher values(8,'Shaiakha',33,'maths',31/07/18,20000,'f');
select * from teacher;
select instr(name,'al')from teacher;
select max(salary) from teacher where genderu003d'f';
select name,age from teacher order by age asc;
select substr(name,3,5) from teacher;
select department,count(department) from teacher group by department;

create table student(admno int,name char(25),class int,sec char(5),rollno int,address char(25));
insert into student values(1271,'Utkarsh Madaan',12,'C',1,'pb');
insert into student values(1324,'Naresh Sharma',10,'A',1,'mn');
insert into student values(1325,'Md. Yusuf',10,'A',2,'cn');
insert into student values(1328,'Sumedha',10,'B',23,'mn');
insert into student values(1364,'Subya Akhtar',11,'B',13,'jp');
insert into student values(1434,'Varuna',12,'B',21,'r');
insert into student values(1461,'David DSouza',11,'B',1,'mt');
insert into student values(2324,'Satinder Singh',12,'C',1,'gp');
insert into student values(2328,'Peter Jones',10,'A',18,'ve');
insert into student values(2371,'Mohini Mehta',11,'C',12,'rg');
select class,count(*) from student group by class;
select(now());
select name from student order by name desc;
select right(address,6) from student;
select ucase(name) from student;

Rishabh Rathi 60 months ago

The place is good and the best part is that it remains open even on sunday.

Manan Patelia 60 months ago

No good services at all