Problem
Write SQL Code for the following
A. List last name of all students whose first name is longer than 4 letters in ascending order according to the last name. Duplicated rows should be removed from the output.
B. Count the total number of rooms in Location.
C. Find the number of students in each major.
D. Find the number of employees in each department who get no commission or have salary less than 5000.