create customer table in sql by orcal

 **Create customer table**

create table customer (customerid varchar2(10), Name varchar2(10),city varchar2(10));

insert into customer values('c10100','steve','agra');

insert into customer values('c10111','raghu','agra');

insert into customer values('c10115','charu','noida');

insert into customer values('c10117','ajeet','delhi');

insert into customer values('c10118','carl','delhi');

**Where condition by select oprator**

1st*

select name,customerid

from customer

where city='agra'and customerid='c10100';

2nd*

select name,city

from customer;