Discuss the below:
Q1. 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.
SELECT StudentID, FirstName, LastName, GPA
FROM Students
WHERE Year like '%FR%' AND GPA >= 3.5
Q2. 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.
SELECT *
FROM Students
WHERE GPA < 3.0 and Year like '%JR%' OR '%SR%'
ORDER BY LastName DESC