Explore BrainMass
Share

Improvements to SQL queries for Student data

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

I have tried there two queries, but I am told that I am not doing something right. Here are the criteria I used to write the queries and my current answers.
1. Write a SELECT statement that lists the StudentID, FirstName, LastName, and GPA of freshman (FR) whose GPA is 3.5 or higher. Use only the Student table.
My query:
SELECT StudentID, FirstName, LastName, GPA
FROM Students
WHERE Year like '%FR%' AND GPA >= 3.5

2. Write a SELECT statement that returns all the information for junior and senior students whose GPAs are lower than 3.0. Sort by LastName in descending order. Use only the Students table.
My query:
SELECT *
FROM Students
WHERE GPA < 3.0 and Year like '%JR%' OR '%SR%'
ORDER BY LastName DESC

How can I edit my queries so that they are completely correct. The SQLyog is returning the correct answers, but I keep getting marked incorrect.

© BrainMass Inc. brainmass.com March 21, 2019, 7:16 pm ad1c9bdddf
https://brainmass.com/computer-science/sql/improvements-sql-queries-student-data-285712

Solution Preview

Student, since you say "SQLyog is returning the correct answers" I suspect we only need to tweak your queries a bit. To be sure, I would liked you to have attached your query output and the Students table schema. I think the problem you are getting in your marks is because you are using "Year like" when you should use an "=" comparison. "=" is a more SARGable search parameter than "LIKE", meaning SQL is optimized to returnig "=" results faster and more efficiently using ...

Solution Summary

The solution is a careful analysis to the queries as given for improvements.

$2.19