Write the following queries in SQL.

1. Consider the following database schema describing students enrolled in sections of classes at a university. student (sid*, sname, sex, age, year, gpa) [Year is a number between 1 and 5). dept(dname*, numphds) prof(pname*, dname) course(cno*, cname, dname*) (Course numbers are unique within departments.] major(dname*, sid*) section(dname*, cno*, sectno*, pname) (Associates an instructor to a section.] enroll(sid*, grade, dname*, cno*, sectno*) (Associates students to sections. (c) For each course with an average grade of at least 3.0, print the course number, department name, enrollment and average grade. Assume that the enrollment of a course is the sum of the enrollment of all its sections. (d) For each department, show information about the student(s) with the highest gpa who major in the department. In particular, for each such student, we want to show the student id, student name and gpa, and the department name the student is major in. If there are ties, show all students with that gpa. (e) Find all courses whose titles contain the word "Programming" (f) How many different letters are used to start the names of students? Hint: In SQL you can get the first letter of a strings as substring(8,1,1)