SQL

gistfile1.sql

create table students ( f_name string , l_name string , id int , score float , status string ) ;

insert into students parameter ( f_name , l_name , id , score , status ) values ( ali , irani , 45 , 20.0 , passed ) ;
insert into students parameter ( f_name , l_name , id , score , status ) values ( pooya , parsa , 48 , 15.6 , passed ) ;
insert into students parameter ( f_name , l_name , id , score , status ) values ( masoud , bonabi , 12 , 17.3 , passed ) ;
insert into students parameter ( f_name , l_name , id , score , status ) values ( fellan , bahman , 1 , 9.9 , failed ) ;

update from students set status = pending ;
update from students set status = special where id = 12 ;

select * from students
select * from students where score = 9.9 ;

#delete from students where f_name = pooya ;
#delete from students ;
#drop students ;