3.9 lab - select lesson schedule with inner join the database has three tables for tracking horse-riding lessons: horse with columns: id - primary key registeredname breed height birthdate student with columns: id - primary key firstname lastname street city state zip phone emailaddress lessonschedule with columns: horseid - partial primary key, foreign key references horse(id) studentid - foreign key references student(id) lesson datetime - partial primary key write a select statement to create a lesson schedule with the lesson date/time, horse id, and the student's first and last names. order the results in ascending order by lesson date/time, then by horse id. unassigned lesson times (student id is null) should not appear in the schedule. hint: perform a join on the student and lessonschedule tables, matching the student ids. 304864.2006078.qx3zqy7