create view <Viewname> as
select a as A,b as B,c as C 
from <tablename>
where <whereclause{optional}> order by A

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Using Views
CREATE VIEW [Current Product List] AS
SELECT ProductID,ProductName
FROM Products
WHERE Discontinued=No

CREATE VIEW vino (view_name) 
AS
SELECT mark1 (column_name(s))
FROM stud(table name)
WHERE avg>80 (condition)

CREATE VIEW <View Name> AS <Query Goes here>