SQL Basics: Retrieving Data with the 'SELECT' statement

The SELECT Statement: Is one of the most frequently used statements in SQL, and its purpose is to retrieve information from one or more tables.

Objective: The goal of this post is to highlight some of the various ways we can retrieve data from table(s) using the SELECT.

Data: The data for this post was obtained from UNAIDS, an organization leading the global effort to end AIDS as a public health threat by 2030. The data represents the prevalence of HIV, total (% of population ages 15-49). A subset of the data in this example was obtained from https://data.worldbank.org/indicator/SH.DYN.AIDS.ZS?view=chart. Data retrieved 1-18-20

Method: This post used the python libraries pandas, and SQLAlchemy were used in conjunction with jupyter notebook to run the MySQL SELECT commands. This was done for ease of displaying the results. All SQL commands are in red.