Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Assignment
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%';
run
|
edit
|
history
|
help
0
SQL social network practice by Han Wang 20200720 - 2
75 95
PostgreSQL Sandbox: General Resale
1097. Game Play Analysis V
PostgreSQL aggregate JSON recordset keys by row
histogram to percentiles
base de datos api teclab
Persy_Jackson
Returning IDs with exactly 3 consecutive months of invoice_amt >2000
Ass2 q2