MYSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the WHERE clause in MySQL?

How would you retrieve all rows from a table named products where the price is greater than 100?

How can you use the WHERE clause to filter rows based on multiple conditions?

How do you use the WHERE clause with the LIKE operator in MySQL?

What is the difference between the WHERE and HAVING clauses?

How can you use the WHERE clause with the IN operator?

How would you use a subquery within the WHERE clause?

How can you use the WHERE clause to filter results based on a date range?

Explain how to use the WHERE clause with NULL values.

During a database certification exam, you are asked to write a query that retrieves all products that are either out of stock or have a discount greater than 20%. What would your query look like?