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
Phone Number with area code
Second Table – GPA
Third Table – Scholarships
Major course of study
Academic Scholarship (Yes or No)
Athletic Scholarship (Yes or No)
Write it like this: SELECT Students.[First Name], Students.[Last... View the full answer
- Thank you for your patience. Any questions or clarification is welcomed.
- Jul 20, 2016 at 8:59pm
Sign up to view the full answer
Please check the data type of... View the full answer
- check the data type in the table?
- 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
- Jul 19, 2016 at 10:01pm
- Give the precision in number also
- Jul 19, 2016 at 10:31pm