Question

define the two views of table​

Answer 1

$\huge{\underline{\underline{\mathfrak{Answer}}}}$

An inline view is a SELECT statement in the FROM-clause of another SELECT statement to create a temporary table that could be referenced by the SELECT statement. Inline views are utilized for writing complex SQL queries without join and subqueries operations