Write SQL query that would produce these results.

Display the number of students from each class that got an A or B in the course.

className grade count(grade)

Database A 3

Database B 2

Computer Based IS A 3

Computer Based IS B 3

Display the className, grade and how many students got an A, B or C in the class. Filter the data to only display the class and grades where there is a count less than 3.

className grade count(grade)

Database B 2

Database C 2

Computer Based IS C 1

Display the last name of all students who have more than 8 characters in their name. The query results should only display unique values (no duplicate results). The results should appear in descending alphabetical order.

lName Lenth

Stephenson 10

OConnell 9

McRoberts 9