Write a select statement returns all the information


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

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: Write a select statement returns all the information
Reference No:- TGS01938999

Now Priced at $25 (50% Discount)

Recommended (97%)

Rated (4.9/5)