When writing SQL queries, do the commands, like
FROM have to be all capital letters?
No, SQLite, which Codecademy uses, is case-insensitive when it comes to clauses like
FROM which can be cased in any way. This is different from other programming languages such as Python where casing is quite important.
/* Both of the following queries will return the same result. */ SELECT * FROM table; select * from table;