list the last name and salary of employees who earn between $5,000 and $12,000, and are in department 20 or 50. Label the columns Employee and Monthly Salary, respectively.

Show students’ first name and last name, the course numbers the student took (don’t include currently taking) and its credits, and the grades of the courses in the ascending order of last name and first name and descending order of course number STUDENT TABLE 100001 Johnson Ariel 2000-07-10 Y 100002 Green Robin 2001-11-02 Y 100003 Johnson Charles 1995-01-12 Y 100004 Pearson Jeffery 1996-02-06 Y 100005 Sears Miguel 1998-10-31 Y 100006 Kyle Leah 2000-05-29 Y 100007 Myers Lynda 1980-08-24 Y

QUESTION 4 Convert the following ER diagram into a relational database schema, be certain to indicate primary keys and referential integrity constraints. Accident Driver reportNUM driverlD PK PK location Address accidentDate Name have

List the name of all departments that have more than four courses (you are not allowed to use join). OnlineCourse Department DepartmentiD OnsiteCourse CourselD CourselD URL Name Location Budget Days StartDate Time Administrator StudentGrade Course EnrollmentiD CourselD CourselD Title StudentiD Credits Grade DepartmentiD Person Courselnstructor PersonID CourselD LastName PersoniD FirstName HireDate EnrollmentDate