How to rename result set of COUNT(*) in SQL

Question

We were asked to create a SQL statement to show the count of customers whose country is USA. The column name of the result set should then be renamed into numcustomers.

The database is in here: http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all.

I already found the count(*) of customers in the USA:

SELECT * 
FROM Customers
WHERE Country = 'Germany'

But I can't figure out how to rename COUNT(*) into numcustomers. Any help?

Answer 1

SELECT count(*) AS numcustomers FROM Customers
WHERE Country = 'USA'

Use AS keyword to set column alias.

Answer 2

Akshey Bhat is right

SELECT 
    count(*) AS numcustomers 
FROM Customers
WHERE Country = 'USA'

This query to get a number of usa customer and this index name is numcustomers or column name is numcustomers