SELECT statement is commonly used command in SQL server.
We use select statement to retrieve data that follow the conditions we previously specified.
To get distinct values from the table we use SQL distinct statement.
We use count statement to count number of rows from the table.