Use Single Sql Statement Following Questions 1 Give Listing Ssns First Names Class Descrip Q37275266

Use only a single SQL statement for each of thefollowing questions

1. Give a listing of all the ssns,first namesand the class descriptions of all the classes the students aretaking. If there are no class_descriptions display ‘No descriptionis available yet’. (USE NVL)

2. Give a listing of only the lname and theclass_code for students who are taking ‘Introduction to Cprogramming’. (Inner join)

3. Give a listing of all the class_descriptionsand the number of students enrolled in each class for all studentswho are older than the average age where the total number ofstudents for the class is more than 1 student. Order by the

OR

 

OR