VIEWS
64.2
Exercise

VIEWS - 1

Write a set of SQL statements to:

  1. Create a VIEW basicStudentData that contains these four columns: name, age, grade, marks. The data should be the name, age, grade and marks for all the students.

  2. Display all data from the VIEW basicStudentData.