having, group by, where, all, any, in

where dept like('__p%')

OLTP -- Online Transaction Processing/ Online Update
RDBMS-  support opltpand olap 

data type- numeric, string and date
show database
truncate - delete only the rows data in table
select power(2,3) answer is 8
select mod(29,3) answer is 2
select least(1,1,2,3) answer is 1 (dont use min)
select greatest () answer is max value
select ucase('abcd')
select lcase('ABCD')