SQL Server

verb.  Upper case in First character  :  Select , Group , Having , Create , Drop , Insert , Delete ...

prep.  lower case in all characters  :  where , as , and , or , by ...

System Function. Upper case in all characters  :  GETDATE , YEAR , COUNT ...