Check out example codes for "mode sql course". It will help you in understanding the concepts better.

Code Example 1

SELECT west AS West_Region,
       south AS South_Region
  FROM tutorial.us_housing_units

Code Example 2

SELECT west AS "West Region"
  FROM tutorial.us_housing_units

Code Example 3

SELECT *        FROM tutorial.us_housing_units

Code Example 4

SELECT *
  FROM tutorial.us_housing_units

Code Example 5

SELECT year,
       month,
       west
  FROM tutorial.us_housing_units

Learn ReactJs, React Native from akashmittal.com