VIEWS

 CREATE DATABASE students2;

USE students2;

CREATE TABLE student(id int primary key,name varchar(90),address varchar(199), marks int, grade varchar(10));

INSERT INTO student(id,name,address,marks,grade)

values(1,'abhi','kmm',80,'A'),

(2,'bharath','hyd',75,'A'),

(3,'ash','kmr',79,'A'),

(11,'viany','kmr',88,'A'),

(4,'joe','us',89,'A'),

(5,'katy','mum',69,'B'),

(69,'dani','kmm',56,'C'),

(6,'lana','kmm',33,'F'),

(7,'thala','jrknd',100,'O'),

(8,'jaddu','guj','97','O'),

(10,'god','mumbai','100','O'),

(18,'king','delhi',100,'O'),

(45,'shana','mumbai',87,'A'),

(17,'alien','ban',199,'F');

CREATE VIEW view1 AS SELECT name,marks,id FROM student;

SELECT * FROM view1 WHERE marks>90;