sql - mysql where clause wrong -

this question has answer here:

• check constraint in mysql not working 6 answers

select c.course_id ,c_title ,start_date ,start_date + duration ,location course c ,offering o o.course_id = c.course_id , o.start_date > sysdate -200;

assuming want rows have cost between £300 , £2000:

select * [table] cost between 300 , 2000 

fill in * columns need.