Problem Statement:
Query all columns (attributes) for every row in theCITY table.

Link:HackerRank - Select All SQL

Solution:

SELECT*FROMCITY;

Explanation:

• SELECT *: The asterisk (*) is a wildcard character in SQL that means "all columns." This part of the query specifies that you want to retrieve all columns from the table.
• FROM CITY: Indicates that you are selecting data from theCITY table.

This query will return all the columns for every row in theCITY table. It's useful when you need to inspect or analyze all data available in the table without any specific filtering or conditions.