select * from ItemMasters

-- Aggregate

-- COUNT() -> returns the Total no of records from table , AVG() returns the Average Value from Colum,MAX() Returns MaX Value from Column

-- ,MIN() returns Min Value from Column,SUM()  sum of total from Column

Select Count(*)  TotalRows,AVG(Price) AVGPrice

,MAX(Price) MAXPrice,MIN(Price) MinPrice,Sum(price) PriceTotal 

FROM ItemMasters

 

-- Scalar 

-- UCASE() -> Convert to  Upper Case  ,LCASE() -> Convert to Lower Case,

-- SUBSTRING() ->Display selected char from column ->SUBSTRING(ColumnName,StartIndex,LenthofChartoDisplay)

--,LEN() -> lenth of column date,

-- ROUND()  -> Which will round the value

SELECT  UPPER(Item_NAME) Uppers,LOWER(Item_NAME) Lowers,

SUBSTRING(Item_NAME,2,3) MidValue,LEN(Item_NAME) Lenths 

  ,SUBSTRING(Item_NAME,2,LEN(Item_NAME)) MidValuewithLenFunction, 

   ROUND(Price,0) as Rounded

FROM ItemMasters