What is all the information about the Marketing department?
SELECT * FROM  departments WHERE department_name  =  'Marketing'
all the information refers to SELECT *; about the Marketing department refers to WHERE department_name = 'Marketing';