I’m trying to wrap my mind around SQL.
We learned that there are two functions when dealing with only one table: selection and projection.
Where Selection retrieved information from the rows and Projection retrieves information from the columns.
This is the example she used in class:
WHERE rating < 8
If you wanted to retrieve the Student ID and Name where age is greater than 24, you would type this SQL command:
SELECT ID, sname
WHERE age > 24