Question

Write SQL queries to answer the following questions: (15 points) a. Which students have an ID number that is less than 50000

Answer 1

Answer:

SELECT * FROM STUDENTS WHERE ID < 50000

Explanation:

If we assume the table is called STUDENTS, then we want to select everything (represented by *), where (like an if statement) the ID (assuming the name of the column) is less than 50000.