title: What are some good examples of applying VIEW in MySQL?
body: <p>I have read about the <code>CREATE VIEW</code> syntax of <code>MySQL</code>, but never used it in practice.</p>
  
  <p>Please show me some examples of its applications.</p>