View the step-by-step solution to:

How do I successfully write this query?

How do I successfully write this query?

Extract the First and Last Name, and GPA of each student who qualifies for the Dean’s List. Sort by GPA, then Last Name, then First Name (1 sort). A GPA of 3.25 is required to make the Dean’s List.

Below is the query that I wrote and I keep getting the error message, "Data type mismatch in criteria expression":



Select Students.[First Name], Students.[Last Name],GPA.[Current GPA]
FROM Students INNER JOIN GPA ON Students.ID = GPA.ID
WHERE (((GPA.[Current GPA])>3.24))
ORDER BY GPA.[Current GPA], Students.[Last Name], Students.[First Name];






The database includes the following tables.


First Table – Students

ID

First Name

Last Name

Address

City

State

Zip Code

Phone Number with area code


Second Table – GPA

ID

Current GPA

Class

Freshman

Sophomore

Junior

Senior

Graduate Student


Third Table – Scholarships

ID

Major course of study

Academic Scholarship (Yes or No)

Athletic Scholarship (Yes or No)

Top Answer

Write it like this: SELECT Students.[First Name], Students.[Last... View the full answer

1 comment
  • Thank you for your patience. Any questions or clarification is welcomed.
    • computer_expert
    • Jul 20, 2016 at 8:59pm

Sign up to view the full answer

Other Answers

Please check the data type of... View the full answer

3 comments
  • check the data type in the table?
    • umyesitsme
    • Jul 19, 2016 at 9:54pm
  • when I change the data type to a number, the gpa becomes a single integer instead like (2,3,4) instead of 2.5, 3.7, 1.6 How do i get it to show as a decimal
    • umyesitsme
    • Jul 19, 2016 at 10:01pm
  • Give the precision in number also
    • JusticeFreedomFalcon102
    • Jul 19, 2016 at 10:31pm

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online