Special Operators:
==================
1) Like operator
================
=> used to search for a specified pattern in a column.
Syntax:
	select col1,col2,col3,...
	from table-name
	where column-name like 'pattern';

%
-
Ex: rav% ==> list/highlight all names which are start with specified 'rav'
rav- => select only one with specified group 'rav'


Q: Write a query to display the customer id and customer name from the customer table
whose name started with 'Pra'.

create table customers1022
(
    customer_Id number(4),
    customer_name varchar2(50),
    customer_location varchar2(30),
    customer_age number(2)
);

insert into customers1022 values(1022,'Prabhakar','Tirupathi',53);
insert into customers1022 values(1012,'Prashanth','Hyderabad',33);
insert into customers1022 values(1002,'Shalini','Bangalore',26);
insert into customers1022 values(1020,'Shravanth','Hyderabad',23);
insert into customers1022 values(1010,'Surekha','Tirupathi',23);
insert into customers1022 values(1011,'Praveen','Pune',36);
insert into customers1022 values(1102,'Prasann','Vizag',31);
insert into customers1022 values(1023,'Ashok','Hyderabad',33);

select * from customers1022;

select customer_Id,customer_name
from customers1022
where customer_name like 'Pra%';

Q-2: Write a query to filter the student Email whose mail id has the domain with '@gmail.com'.

select stuName, email
from students123
where email like '%@gmail.com';
 
2) in and not in operators
--------------------------
=> in and not in are "membership operator".
=> can be used to define data or info based on membership of the specified group.

Syntax:
	select col1, col2, ..
	from table-name
	where col-name in [sequence];

create table employees1102
(
    employeeId number(6),
    employeeName varchar(50),
    department varchar(30),
    workingLocation varchar(30),
    workMode varchar(20)
);

insert into employees1102 values(1022,'Neelima','IT','Bangalore','Work From Office');
insert into employees1102 values(1032,'Neeraj','Accounts','Pune','Work From Home');
insert into employees1102 values(1012,'Ganesh','IT','Bangalore','Work From Home');
insert into employees1102 values(1052,'Santoshi','HR','Hyderabad','Work From Office');
insert into employees1102 values(1042,'Karthik','IT','Bangalore','Work From Office');
insert into employees1102 values(1062,'Keerthi','Admin','Noida','Work From Home');

select employeeName, department
from employees1102
where department in ('Admin','IT');

3) between-and operators
========================
=> to filter the data based on the range, we can use "between-and" operator.
Syntax:
	select col1, col2,....
	from table-name
	where col-name between value1 and value2;

Ex:
select employeeName
from employees
where salary between 100000 and 150000;


Assignment:
-----------
1) Write a query to get the user name, user id and phone number
whose phone number can start with '99'
2) Write any query to describe about the not in operator.