Question 2: Select Firstname, Lastname, Department, Rank, and Salary for all faculty whose last name begins with JO [Hint: use LIKE in your where clause with a syntax LIKE JO*].

Why this is wrong >>>>

SELECT Firstname, Lastname, Department, Rank, Salary FROM Faculty WHERE LastName LIKE 'JO%';

Question 3. Select CourseNo, Title, and the number of times that a course has been offered

[Hint: In this query, you need to retrieve data from two tables Course and Offering. Since it involves a COUNT(*) function in the SELECT phrase, the SQL should also have a GROUP BY phrase after the WHERE phrase. Remember that CourseNo appears in both Course and Offering tables, you need to have join condition and an alias may be needed to make your statement easy to write].