Your are missing your FROM tablename bit
SELECT mdl_scorm_scoes_track.value FROM mdl_scorm_scoes_track where mdl_scorm_scoes_track.element='cmi.core.lesson_status
SELECT mdl_scorm_scoes_track.value FROM mdl_scorm_scoes_track where mdl_scorm_scoes_track.element='cmi.core.lesson_status