Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
employee table
create table employee ( e_id int not null, e_name varchar(20), e_salary int, e_age int, e_gender varchar(20), e_dept varchar(20), primary key (e_id)); insert into employee values(1, 'sam' , 95000 , 45 , 'male' , 'operations' ); insert into employee values (2, 'bob' , 80000 , 21 , 'male' , 'support' ); insert into employee values(3, 'anne' , 125000 , 25 , 'female' , 'analytics' ); insert into employee values(4, 'julia' , 73000 , 30 , 'female' , 'analytics' ); insert into employee values(5, 'matt' , 159000 , 33 , 'male' , 'sales' ); insert into employee values(6,'jeff' , 112000 , 27 , 'male' , 'operations' ); select * from employee; select e_name from employee; select e_gender from employee; select distinct(e_gender) from employee;
run
|
edit
|
history
|
help
0
2021.02.25 Lab 4
text
Lisber-SQL-Example(CASE)
Libros
Loan
TESTE PLATAFORMA
NAMES CODE
robot-grading
Empresa
bvbn