SQL insert with select and hard-coded values

Question

For illustration purposes, let's say I have a database Movies(Title, Director, Cost, Profits).

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.

INSERT INTO Movies  SELECT name    FROM Directors   WHERE name = 'Lucas'; 

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:

INSERT INTO Movies  VALUES(Star Wars,(SELECT name                      FROM Directors                     WHERE name='Lucas'), 50000, 1000000); 

Is this possible?

Answer 1

INSERT INTO Movies (Title, Director, Cost, Profits) SELECT 'Star Wars', name, 50000, 1000000 FROM Directors WHERE name = 'Lucas' 

Answer 2

Because you can specify hardcoded values in the select statement, it's probably cleaner to use:

insert into movies (title, director, cost, profits)    select 'Star Wars', name, 50000, 1000000 from directors where name = 'Lucas';