How to select columns from a single database table using SQL in DB Browser for SQLite part 2

A quick SQL tutorial:
How to select columns from a single database table using SQL
in DB Browser for SQLite part 2

SQL Commands mention in this video are as follows:
CREATE VIEW AS
SELECT FROM ,
WHERE , AND , OR , NOT

* if you use AND and OR in WHERE, AND will be executed first, may differ depending on system (but still good to know)*

Public Domain source of Minimum wage data set used in video:
Was scraped then shared on Kaggle.com by the user name Lislejoem :
Below is a link to Lislejoem Kaggle.com page for the data set.


Below is his public GitHub page showing how he used R to pull the data.


Reported, original sourced of data set:
U.S. Department of Labor :



Below is a link to my own GitHub page:

SQL,SQL tutorial,DB Browser for SQLite,selecting columns with SQL,database,database management,SQL commands,