Group Function

Select Col_Name, Funtion_Name(Col_Name) From Table_Name
Where Col_Name Group By (Col_Name)
e.g
Select Employees,Sum(Price) From Technology Group By Customer

Lcase Funtion

Select Lcase(Col_Name) From Table_Name
e.g
Select Lcase(Last_Name) From Technology

Ucase Function

Select Ucase(Col_Name) From Table_Name
e.g
Select Ucase(First_Name) From Technology

Last Function

Select Last(Col_Name) From Table_Name
e.g
Select Last(Price) as 'Price' From Technology