Get fast, custom help from our academic experts, any time of day.
Place your order now for a similar assignment and have exceptional work written by our team of experts.
Secure Original On Schedule
Hello,
Please write the SQL queries mentioned in the below PDF Submit your responses as a PDF file .
1. Write a query that produces a list of student names and their GPAs.
2. Write a query that shows each student status (Fr, So, Ju, Se) along with the highest GPA
of that student status. 3. Write a query that shows all information about the contests between the dates 06/01/2012
and 12/29/2012.
4. Write a query that shows the points awarded (the sum of the first, second, and third
places) in each of the contests between the dates 06/01/2012 and 12/29/2012 along with
the date of the contest.
5. Write a query that shows the average of the points awarded by the contests from problem
4. (Think about using a nested query in the from clause.) 6. Write a query that shows the number of students enrolled in each course section in the
Sections table. 7. Write a query that lists the names of professors who have not taught any freshman
students (students with status Fr). 8. Write a query that returns a list of all contest winners (first, second, or third place) along
with the points they won. (Think about using the union operator for this one.) 9. Using the query from problem 8, write a query that shows the name, breed, and points
won by each dog for each contest they won. 10. Using the query from problem 9, write a query that shows the sum of the points won for
each breed of dog.
11. Using the query from problem 10, write a query that shows the sum of the points won for
each breed of dog, but only for breeds with sums greater than 1000 points.
12. Show the name, status, and GPA of the students with the maximum GPAs within their
status. (Think about the All operator with a nested query.) 13. Increase the number of points awarded to the first-place winners of contests between the
dates of 06/01/2012 and 12/29/2012 by 100 points.
14. Delete the contests between the dates of 06/01/2012 and 12/29/2012.
Get fast, custom help from our academic experts, any time of day.
Secure Original On Schedule