code. compile. run. debug. share.
Source Code
Language
create table employees(
f_name text, -- f - first, l- last, b - before, d-department, no-number, e-employee
l_name text,
d_no int,
e_id int,
salary int
);
insert into employees(f_name, l_name,d_no,e_id,salary) values
("Neena","Kines",1,101,19000 ),
("Peter","Paul",2,123,120000 ),
("Mary","Pera",3,420,5000 ),
("Rogers","Kers",1,534,3000 ),
("Rahul","Maneul",3,456,8780 );
select * from employees;
select "______________________________________________";
select f_name, l_name,d_no,salary from employees where salary>8000;
select "______________________________________________";
select f_name, l_name, d_no from employees where l_name="Maneul";
select "______________________________________________";
select f_name, salary from employees order by f_name;
select "______________________________________________";
select sum(salary) from employees;
select "______________________________________________";
select avg(salary) from employees;
select "______________________________________________";
select * from employees where f_name="Neena" and e_id=101;
select "______________________________________________";
select count(f_name) from employees;
select "______________________________________________";
Compiling Program...
Standard Input:
Interactive Console
Text
Program is not being debugged. Click "Debug" button to start program in debug mode.
| # | Function | File:Line |
|---|
| Variable | Value |
|---|
| Register | Value |
|---|
| Expression | Value |
|---|
| # | Description |
|---|