How to Count Rows in SQL and Renaming Result Column with Alias

Learn how to use Structured Query Language (SQL) to count the number of rows in a database table.
In particular, you learn how to use the COUNT function to find out the number of rows found with your query. You also learn how to alias a column name with the AS keyword.