Which clause is used to "Filters out unwanted data"?

Solution (By Examveda Team)

This question is about how to pick out specific information from a database using SQL (Structured Query Language). Imagine you have a big table full of data like a spreadsheet, and you only want to see certain rows. That's where the WHERE clause comes in!

Think of it like using a filter on a coffee machine – you choose the criteria, and the filter only lets through what you want. The WHERE clause lets you set conditions to pick specific rows based on values in your columns.

Let's look at the other options:
* FROM tells the database which table you want to work with.
* SELECT chooses which columns you want to see.
* ORDER BY arranges the rows in a specific order.

So the answer is Option B: WHERE.