Write a query that returns the first name of a student whose last name is "Patil" and is in the Ravenclaw house. How do you do this?

SELECT first_name FROM student WHERE last_name = "Patil"

Explanation:

The SELECT clause is used to read data from a table in a relational database, the FROM clause specifies the table from which data is retrieved while the FROM clause returns the rows of data that meet a given condition.