Count Function. To find Number of Rows in Table

 To find the number of rows in the table, query is below

The column name can be set as desired using the key word " as "(shown in the SQL).