Assignment, PostgreSQL

Language: Layout:

drop table customer cascade;
create table customer(Customer_ID char(10) primary key,Name
char(25),Area char(3),Phone numeric(7));
insert into customer values('101','Alwin','abc',2788664);
insert into customer values('102','Amal','akg',2788552);
insert into customer values('103','Benny','kgf',2788664);
insert into customer values('104','Kelvin','abc',2781964);
insert into customer values('105','kalidas',NULL,2788655);
insert into customer values('106','Kiran',NULL,2788264);
--(a)
alter table customer alter column phone type numeric(10);
update customer set phone=phone+4800000000;
--(b)
select * from customer;
--(c)
select Name from customer where name like '_e% ';
--(d)
select name from customer where area = 'abc';
--(e)
delete from customer where area is NULL;
--(f)
select * from customer order by name asc;
--(h)
select area,count(area) from customer group by area;
--(i)
select * from customer where name like 'A%' or area ='abc';
--(j)
alter table customer alter column phone type char(10);
select * from customer where phone like '%55%';


absolute service time: 0,45 sec