SQL Practice

I practiced SQL and it was really annoying at first but I think I am getting the hang of it. I started by making a table of presidents but I had trouble inserting values and I didn't quite understand the syntax so then I just made a random table with random values and got everything working. So it is possible to make data tables through vim or through SQL? I made mine using SQL, should I know how to do it through vim too?
 

This is what I did, unfortunately it took me a long time to figure out
sqlite> CREATE TABLE test(
   ...> stuff varchar,
   ...> garbage varchar,
   ...> random varchar);
sqlite> insert into test (stuff, garbage, random) values (blah, spam, woop)
   ...>
Error: no such column: blah
sqlite> INSERT INTO test(stuff, garbage, random) VALUES ("blah", "spam", "woop");
sqlite> select * from test;
blah|spam|woop