SQL views practice: CREATE VIEW, views on views and DROP VIEW
SQL · Lesson 8
Ctrl/⌘ + Enter to run
✓
SQL Lesson 8 done.
The shop's questions now have names. job_list saves the three-table join, open_jobs is always this morning's garage, job_totals and job_bills stack one view on another, and the supplier gets parts_usage with the prices left out. You saw that a view stores a query and no rows, so it follows every change in its tables, that it can't be written to in SQLite, and that changing one means DROP VIEW and CREATE VIEW again.
More SQL practice
SQL practice onlineSQL skills testSQL SELECT practiceSQL GROUP BY practiceSQL JOIN practice exercisesSQL subquery practicePrimary and foreign key practiceDatabase normalization practiceSQL constraints practiceSQL reference with queries you can runSQL errors, with a query to fixSQL interview questions, with answersExcel practice onlineLearn to read financial statements