How Do I Make a View?

CREATE VIEW vendors_min AS

SELECT vendor_name, vendor_state, vendor_phone

FROM vendors

Creating a View is not difficult, just wrap your SELECT in a View

Wow, this gives me an Idea from the start of the lecture, remember the NoSQL data we cleaned up?