What is the right way to write this SQL Query?

5 pts.
Tags:
SQL
SQL Query
I keep getting SYNTAX errors when I try to write this query, what is the proper way to write this query? Query question and table information is below. Return the last name and GPA of the top ten students by Cumulative GPA for students that were enrolled in at least one class during January 1, 2016.
Student Table:
StudentID           int
FirstName           varchar(30)
LastName                varchar(30)
StudentNumber     varchar(20)
Status                  char(1)
StartDate                 date
Class table:
ClassID                int
Department            varchar(30)
ClassNumber          int
ClassName         varchar(50)
Description         varchar(400)
StudentEnrollment Table
StudentID   int
ClassID        int
Section         int
Instructor    varchar(80)
Room           varchar(10)
IsOnline       int
Year             int
Semester     int
ClassDays    varchar(5)
StartDate     date
Grade           number(10,1)



Software/Hardware used:
database query question
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    OK we see the table data, what does your select statement look like?? Post what you have tried and your results and any errors..
    It sounds like homework and we can help but we do not do it for you.
    128,275 pointsBadges:
    report
  • carlosdl
    What is the query you are trying?

    We have no way to know why you are getting syntax errors if you don't post your code.

    Also, if you want tested solutions, you would need to post the actual scripts to re-create your table and INSERT statements with some sample data, along with the exact results you would want to get from that sample data.
    84,580 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: