SELECT * FROM  departments WHERE department_name  =  'Marketing'
display all the information about the department Marketing.
SELECT * FROM departments WHERE department_name = 'Marketing '
select * from departments where department_name = value
display all the information about the department Marketing .