Finding the min and max length of movies in sqlite

I need to find the min and max length out of several hundred movies in a sqlite table. I've never done this before. SELECT * FROM movies WHERE length? The columns include id, name, length, director. Length is shown as 1:45:00.