1)IN operator
The IN operator is used to compare a list of literal values that has been specified
Syntax
SELECT column_name(s) From table_name WHERE column_name IN (value1,value2,..);
(or)
SELECT column_name(s) FROM table_name WHERE column_name IN(SELECT statement);
2)HAVING Clause Operator
The HAVING clause was added to SQL because WHERE keyword cannot be used with SQL
Syntax
SELECT column_name(s) FROM table_name WHERE condition GROUPBY column_name(s) HAVING condition ORDER BY column_name(s)
