/codebasics
COURSE SQL Advanced: Top Customers, Products,
TITLE Markets
CHAPTER
TITLE
Database Views: Post Invoice Discount, Net Sales
1 One cannot directly add the derived column in the
base query hence, CTEs, Sub Queries, or Views are
required.
2 It is possible to create multiple views out of the
base table.