SQL views

In my own words, sql views is a virtual table created by getting partial (or even full) data from a table or combination of tables.

Normal sql queries can be used to retrieve data from Views like any other table.