What is the diference between CREATE VIEW and SELECT statement? thks

Answer 1

To the best of my understanding with regular select you work on actual data from an actual table(s) that exists in your data set. However with create view you generated a new, virtual, table that users can altet without making changes to the original one(s).

Answer 2

view is a database object stored in database that allows you to use DML statement on it .
on the other hand the SELECT statement allows you to display
the data and stored temporarily in the memory for the current use only.

Answer 3

using select allows you to manipulate the data in your tables even merge some tables together but its only for that time that the statements are rendered. if you create a view you can merge tables and data form other tables that will stay and can be called later in your work.