-
need help
Can someone do this exercise for me:???
Instructions:
Given the following table layouts for STUDENTS, TRANSCRIPT, and COURSES with Primary Keys and Foreign Keys
STUDENTS
TRANSCRIPT
COURSES
StudentID (Primary)
TranscriptID (Primary)
CourseID (Primary)
FirstName
StudentID (Foreign)
CourseName
LastName
CourseID (Foreign)
Credits
Major
Semester
Grade
Write the following queries in SQL:
1. List the names of all the English majors.
2. List the names of the students in US History.
3. List all the courses all students have taken including the grade, when taken and the course name. List the students alphabetically.
4. List all students and the total number of credits earned (for each student.)
NOT NESSERY FOR FREE!!!
-
Isn't this why you were taking the course in the first place?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules