keep getting sytax erros, unknown columns, ambiguous, field list errors. thanks

using MySQL Workbench 8 Create a new schema Reverse engineer the newly created schema. The new model will be needed to perform the following tasks. Before proceeding with following tasks, analyze the data in each of the tables and familiarize yourself with the model. Each of the requirements below require a single SQL statement. Complete the following requirements: Using the UNION operator, do a full outer join to. display the student last name and student program as well as the professor name and professor program. No JOIN operator is to be used in this requirement. Create a query/subquery to display student first name, last name and program. The student program must be same as that in the professor table and the professor program name starts with a C. This query will use a subquery and not a join. Create a query to display the professor ID, professor name and mentor column including records where the professor ID is not on the student_professor table. Note, this will be a left join. Make sure to eliminate duplicates from the output. Display the average age of students in each student program. Display the number of students in the Computer Science program. Display the youngest age of all students. Display the oldest age and average age of all professors. Display the number of mentored students for each ProfessorId

tables and colums are

professor - professorid, porfessorprogram, phoneNo, Age, professorname

student - studentno, studentprogram, phoneno, age, firstname, lastname

student_professor- student_professor_id, professorid, studentno, mentor