Using the university schema, write an SQL query to find the names and IDs ofthose instructors who teach every course taught in his or her department (i.e.,every course that appears in the course relation with the instructor’s department name). Order result by name

SQL DATABASE    need the SQL statements FROM ATTACHED tables  List the trip name of each trip that has Miles Abrams as a guide.   2. For each reservation that has a trip date of July 23, 2016, list the customer’s last name, the trip name, and the start location. 3. List the reservation ID, trip ID, and trip date for reservations for a trip in Maine (ME). Use the IN operator in your query. 4. Repeat Exercise 3, but this time use the EXISTS operator in your query. 5. Find the guide last name and guide first name of all guides who can lead a paddling trip 6. Repeat Exercise 5 but use aliases for the table names. 7. Find the trip name of all reservations for hiking trips and sort the results by trip name in ascending order. 8. List the number and name of each customer that lives in the state of New Jersey (NJ) and that currently has a reservation. 9.  Find the trip ID and trip name for each trip whose maximum group size is greater than the maximum group size of at least one trip that has…

Using the university schema, use SQL to do the following: For each student whohas retaken a course at least twice (i.e., the student has taken the course at leastthree times), show the course ID and the student’s ID.Please display your results in order of course ID and do not display duplicaterows.