title: SQL insert with select and hard-coded values
body: <p>For illustration purposes, let's say I have a database Movies(Title, Director, Cost, Profits).</p>
  
  <p>Now I would like to insert a new row into the Movies table based on a director found in another table and then hard coded values.</p>
  
  <pre><code>INSERT INTO Movies 
  SELECT name 
    FROM Directors 
   WHERE name = 'Lucas';
  </code></pre>
  
  <p>Is how I understand select inserts work but what if I want to use the select as well as pass in hard coded values. So something theoretically like this:</p>
  
  <pre><code>INSERT INTO Movies 
  VALUES(Star Wars,(SELECT name 
                      FROM Directors 
                     WHERE name='Lucas'), 50000, 1000000);
  </code></pre>
  
  <p>Is this possible?</p>