Enterprise EXAM study guide - ASSIGNMENT 2

Enterprise EXAM study guide - ASSIGNMENT 2 List all details of students whose firstname begins with "D" - ANSWER SELECT * FROM students WHERE firstname LIKE 'D%' How many students have firtnames beginning with "A"? - ANSWER SELECT COUNT(*) FROM students WHERE firstname LIKE 'A%' "List the firstname and lastname of students whose firstname and lastname begin with "A". - ANSWER SELECT firstname, lastname FROM students WHERE firstname LIKE 'A%' AND lastname LIKE 'A% List the firstname and lastname of students whose firstname or lastname begins with "A" - ANSWER SELECT firstname, lastname FROM students WHERE firstname LIKE 'A%' OR lastname LIKE 'A%' "List the firstname and lastname of students whose firstnames have at least five characters - ANSWER SELECT firstname, lastname FROM students WHERE firstname LIKE "_____%" "For each section, list the course id, section name and the instructor's first and last names. " - ANSWER SELECT course_id, section_name, firstname, lastname FROM sections s JOIN instructors i on uctor_id = uctor_id "For each registration, list the course id, section name and the student first and last name. - ANSWER SELECT course_id, section_name, firstname, lastname FROM registrations r JOIN students s ON nt_id = nt_id "For each section, list the course name, section name and the instructor's first and last names. " - ANSWER SELECT course_name, section_name