DISPLYING EMP DETAILS MONTH WISE WITH MONTH NAME

select datepart (month, HIRE_DATE) 'month', count(*) 'no of employees'
from EMPLOYEE_NANDU group by datepart(month,HIRE_DATE)

-----DISPLYING EMP DETAILS MONTH WISE WITH MONTH NAME---------

SELECT  MONTH=DATENAME(MM,HIRE_DATE) , count(*) 'no of employees'
FROM EMPLOYEE_NANDU GROUP BY DATENAME(MM,HIRE_DATE)

----DISPLAYING NAMES MONTH WISE AND NO OF EMPS AND NAMES--------------

DISPLAYING NAMES MONTH WISE AND NO OF EMPLOYEES AND NAMES

SELECT DATENAME(MM,E1.HIRE_DATE)'MONTH' ,COUNT(*) 'NO OF EMPLOYEES', STUFF((SELECT ',' + E2.FIRST_NAME
FROM
 EMPLOYEE_NANDU AS E2
WHERE DATENAME(MM,E1.HIRE_DATE)=DATENAME(MM,E2.HIRE_DATE)
 FOR XML PATH('')), 1,1,'')AS ENAME
FROM EMPLOYEE_NANDU AS E1 WHERE HIRE_DATE IS NOT NULL GROUP BY DATENAME(MM,HIRE_DATE)

Word Count in a Sentence

namespace word_count
{
    class Program
    {
        static void Main(string[] args)
        {

            string str = Console.ReadLine();
              int last = str.Length-1;

  int count = 0;
  for (int i = 0; i <= last; i++)
  {
    if ( char.IsLetterOrDigit(str[i]) &&
         ((i==last) || char.IsWhiteSpace(str[i+1]) || char.IsPunctuation(str[i+1])) )
      count++;
  }

  Console.WriteLine(count);
  Console.ReadLine();
        }
    }
}

how to reverse the sentence witout changing tha words position

ex: hi this is string
rev: ih siht si gnirts






    static void Main(string[] args)
        {
            string str = Console.ReadLine();
            string strrev = "";

            foreach (var word in str.Split(' '))
            {
                string temp = "";
                foreach (var ch in word.ToCharArray())
                {
                    temp = ch + temp;
                }
                strrev = strrev + temp + " ";
            }
            Console.WriteLine(strrev);
            Console.ReadLine();
        }

Deleting related rows in two tables

             --DELETING RELATED COLUMNS IN TWO TABLES----

CREATE TABLE DEP_NANDU(
DEPT_ID INT NOT NULL,
DNAME VARCHAR(20)  NOT NULL,
LOCATION VARCHAR(10) NOT NULL,
CONSTRAINT PK_DEP_NANDU PRIMARY KEY (DEPT_ID))

SELECT * FROM DEPT_NANDU

INSERT INTO DEPT_NANDU VALUES(80, 'TRANSPORT', 'DUBAI')

CREATE TABLE EMPLY_NANDU(EMP_ID INT NOT NULL,
ENAME VARCHAR(20) NOT NULL,
SAL INT,
DEPT_ID INT NOT NULL,
DNAME VARCHAR(15) NOT NULL,


SELECT * FROM EMPLY_NANDU

INSERT INTO DEP_NANDU SELECT * FROM DEPT_NANDU
DELETE * FROM DEP_NANDU


                                     ------ADDING CONSTRAINT-----

ALTER TABLE TABLENAME ADD CONSTRAINT PK_TABLENAME PK(CLMN NAME)

ALTER TABLE EMPLY_NANDU ADD CONSTRAINT PK_EMPLY_NANDU PRIMARY KEY(DEPT_ID)

 INSERT INTO EMPLY_NANDU VALUES(106,'SFSG',5000,90,'SALES')

SELECT * FROM DEP_NANDU
SELECT * FROM EMPLY_NANDU
 ALTER TABLE EMPLY_NANDU DROP CONSTRAINT PK_EMPLY_NANDU

                                --ADDING ON DELETE CONSTRAINT----



ALTER TABLE EMPLY_NANDU  ADD CONSTRAINT FK_DEP_NANDU
 FOREIGN KEY(DEPT_ID) REFERENCES DEP_NANDU(DEPT_ID)
ON UPDATE CASCADE
ON DELETE CASCADE


DELETE DEP_NANDU WHERE DEPT_ID=70