sql follows: SELECT * FROM case_studies WHERE case_study_id = 30