如何在sqlite（android）和查询中创建一个sql视图（CREATE VIEW）？

So I have a table and I want to create another table using "CREATE VIEW" from sql. I need to make a copy of the table that I am working with so I can use it 2x. My sql query would have to be like this:So I have a table and I want to create another