Test Your MySQL Greater Than and Less Than Operators Knowledge

Progress

True / False

In MySQL, the > operator can be used to compare two numeric values.

True False

The > operator in MySQL is used to check if the value on the left is greater than the value on the right.

True / False

The < operator in MySQL cannot be used with string values.

True False

The < operator can be used with string values in MySQL to compare them lexicographically.

True / False

In MySQL, 5 > 3 will return true.

True False

The statement 5 > 3 will return true because 5 is greater than 3.

True / False

In MySQL, the expression SELECT 10 > 5; will return 0.

True False

The expression SELECT 10 > 5; will return 1 because 10 is greater than 5.

True / False

MySQL allows the use of the > operator in the WHERE clause to filter rows.

True False

The > operator can be used in the WHERE clause in MySQL to filter rows based on a condition.

True / False

In MySQL, the comparison NULL > 0 returns true.

True False

Any comparison with NULL in MySQL returns NULL, not true or false, because NULL represents an unknown value.

True / False

In MySQL, you can use the > operator to compare the results of two subqueries.

True False

The > operator can be used to compare the results of two subqueries in MySQL.

True / False

The < operator can be used in MySQL to compare values in different columns of the same row.

True False

The < operator can be used to compare values in different columns within the same row in MySQL.

True / False

In MySQL, the query SELECT * FROM table WHERE column > 100; will select rows where the value in column is greater than 100.

True False

The query will select rows where the value in column is greater than 100.

Q10

True / False

In MySQL, the > operator can be used with date values to compare which date is later.

True False

The > operator can be used with date values in MySQL to determine which date is later.

Q11

Single Choice

Which MySQL query would you use to find all employees with a salary greater than 50,000?

SELECT * FROM employees WHERE salary > 50000; SELECT * FROM employees WHERE salary < 50000; SELECT * FROM employees WHERE salary = 50000;SELECT * FROM employees WHERE salary >= 50000;

The > operator is used to select records where the salary is greater than 50,000.

Q12

Single Choice

What does the following MySQL query return?

SQL Code

SELECT * FROM products WHERE price < 100;

All products priced at exactly 100 All products priced less than 100 All products priced more than 100All products priced at least 100

The < operator selects rows where the price is less than 100.

Q13

Single Choice

Which condition is true for the expression 10 > 5 in MySQL?

True False NullUndefined

The > operator compares two values and returns True if the left value is greater than the right value.

Q14

Single Choice

Given the table orders, which MySQL query finds orders placed before 2023-01-01?

SQL Code

+----+-------------+------------+
| id | order_date | total |
+----+-------------+------------+
| 1 | 2023-01-02 | 250.00 |
| 2 | 2022-12-15 | 500.00 |
| 3 | 2023-02-10 | 150.00 |
+----+-------------+------------+

SELECT * FROM orders WHERE order_date < '2023-01-01'; SELECT * FROM orders WHERE order_date > '2023-01-01'; SELECT * FROM orders WHERE order_date = '2023-01-01';SELECT * FROM orders WHERE order_date <= '2023-01-01';

The < operator is used to filter records with an order_date before '2023-01-01'.

Q15

Single Choice

Which MySQL query correctly finds all students with grades greater than 85?

SQL Code

+----+--------+-------+
| id | name | grade |
+----+--------+-------+
| 1 | Alice | 88 |
| 2 | Bob | 76 |
| 3 | Carol | 92 |
+----+--------+-------+

SELECT * FROM students WHERE grade > 85; SELECT * FROM students WHERE grade < 85; SELECT * FROM students WHERE grade >= 85;SELECT * FROM students WHERE grade <= 85;

The > operator selects students with grades strictly greater than 85.

Q16

Single Choice

What does the following MySQL query return?

SQL Code

SELECT COUNT(*) FROM inventory WHERE quantity < 10;

Number of items with quantity more than 10 Number of items with quantity exactly 10 Number of items with quantity less than 10Total number of items in the inventory

The < operator is used to count rows where the quantity is less than 10.

Q17

Single Choice

Which MySQL query would you use to find all employees whose age is between 30 and 50 years?

SQL Code

SELECT * FROM employees WHERE age > 30 AND age < 50;

SELECT * FROM employees WHERE age >= 30 AND age <= 50; SELECT * FROM employees WHERE age > 30 AND age < 50; SELECT * FROM employees WHERE age = 30 OR age = 50;SELECT * FROM employees WHERE age BETWEEN 30 AND 50;

The > and < operators select employees older than 30 but younger than 50.

Q18

Single Choice

What is the result of the following MySQL query?

SQL Code

SELECT * FROM sales WHERE revenue > 1000 OR revenue < 500;

Sales with revenue between 500 and 1000 Sales with revenue either greater than 1000 or less than 500 Sales with revenue equal to 1000Sales with revenue equal to 500

The > and < operators are combined with OR to select records where the revenue is either more than 1000 or less than 500.

Q19

Single Choice

Which MySQL query correctly identifies employees whose salary is less than the average salary?

SQL Code

SELECT * FROM employees WHERE salary < (SELECT AVG(salary) FROM employees);

SELECT * FROM employees WHERE salary < (SELECT SUM(salary) FROM employees); SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees) SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees);SELECT * FROM employees WHERE salary < (SELECT AVG(salary) FROM employees);

The < operator compares each employee's salary with the average salary, returning those who earn less.

Q20

Single Choice

What will the following MySQL query return?

SQL Code

SELECT * FROM transactions WHERE amount > 0 AND amount < 1000;

All transactions with an amount equal to 1000 All transactions with an amount less than or equal to 1000 All transactions with an amount greater than 0 and less than 1000All transactions with an amount greater than 1000

The > and < operators are used to select transactions where the amount is between 0 and 1000, exclusive of the bounds.

Q21

Multiple Choice

Which query correctly retrieves records from the 'employees' table where 'salary' is greater than 50000?

SQL Code

SELECT *
FROM employees
WHERE salary > 50000;

SELECT * FROM employees WHERE salary > 50000; SELECT * FROM employees WHERE salary < 50000; SELECT * FROM employees WHERE salary = 50000;SELECT * FROM employees WHERE salary >= 50000;

The '>' operator is used to filter rows where the 'salary' column has a value greater than 50000.

Q22

Multiple Choice

Identify the correct SQL query that retrieves records from the 'orders' table where 'order_amount' is less than 1000.

SQL Code

SELECT *
FROM orders
WHERE order_amount < 1000;

SELECT * FROM orders WHERE order_amount < 1000; SELECT * FROM orders WHERE order_amount > 1000; SELECT * FROM orders WHERE order_amount = 1000;SELECT * FROM orders WHERE order_amount <= 1000;

The '<' operator filters rows where the 'order_amount' column has a value less than 1000.

Q23

Multiple Choice

Which query correctly selects records from the 'products' table where 'price' is greater than 50 and less than 200?

SQL Code

SELECT *
FROM products
WHERE price > 50
AND price < 200;

SELECT * FROM products WHERE price > 50 AND price < 200; SELECT * FROM products WHERE price >= 50 AND price <= 200; SELECT * FROM products WHERE price < 50 AND price > 200;SELECT * FROM products WHERE price > 50 OR price < 200;

The '>' and '<' operators are used together to filter rows where the 'price' column is between 50 and 200, exclusive.

Q24

Multiple Choice

Determine the correct SQL query that retrieves records from the 'customers' table where 'age' is less than 30.

SQL Code

SELECT *
FROM customers
WHERE age < 30;

SELECT * FROM customers WHERE age < 30; SELECT * FROM customers WHERE age > 30; SELECT * FROM customers WHERE age = 30;SELECT * FROM customers WHERE age <= 30;

The '<' operator is used to filter rows where the 'age' column has a value less than 30.

Q25

Multiple Choice

Which SQL query retrieves records from the 'inventory' table where 'quantity' is greater than 100?

SQL Code

SELECT *
FROM inventory
WHERE quantity > 100;

SELECT * FROM inventory WHERE quantity > 100; SELECT * FROM inventory WHERE quantity < 100; SELECT * FROM inventory WHERE quantity = 100;SELECT * FROM inventory WHERE quantity >= 100;

The '>' operator is used to filter rows where the 'quantity' column has a value greater than 100.

Q26

Multiple Choice

Which query correctly retrieves records from the 'sales' table where 'total_sales' is less than 5000 OR greater than 10000?

SQL Code

SELECT *
FROM sales
WHERE total_sales < 5000
OR total_sales > 10000;

SELECT * FROM sales WHERE total_sales < 5000 OR total_sales > 10000; SELECT * FROM sales WHERE total_sales < 5000 AND total_sales > 10000; SELECT * FROM sales WHERE total_sales < 5000;SELECT * FROM sales WHERE total_sales > 10000;

The '<' and '>' operators are used with the OR condition to filter rows where 'total_sales' is either less than 5000 or greater than 10000.

Q27

Multiple Choice

Determine the correct SQL query that selects records from the 'transactions' table where 'transaction_amount' is greater than 100 AND less than 1000.

SQL Code

SELECT *
FROM transactions
WHERE transaction_amount > 100
AND transaction_amount < 1000;

SELECT * FROM transactions WHERE transaction_amount > 100 AND transaction_amount < 1000; SELECT * FROM transactions WHERE transaction_amount >= 100 AND transaction_amount <= 1000; SELECT * FROM transactions WHERE transaction_amount < 100;SELECT * FROM transactions WHERE transaction_amount > 1000;

The '>' and '<' operators are used together to filter rows where 'transaction_amount' is between 100 and 1000, exclusive.

Q28

Multiple Choice

Which SQL query retrieves records from the 'projects' table where 'budget' is greater than 50000?

SQL Code

SELECT *
FROM projects
WHERE budget > 50000;

SELECT * FROM projects WHERE budget > 50000; SELECT * FROM projects WHERE budget < 50000; SELECT * FROM projects WHERE budget = 50000;SELECT * FROM projects WHERE budget >= 50000;

The '>' operator is used to filter rows where the 'budget' column has a value greater than 50000.

Q29

Multiple Choice

Identify the correct query that retrieves records from the 'clients' table where 'revenue' is less than 200000.

SQL Code

SELECT *
FROM clients
WHERE revenue < 200000;

SELECT * FROM clients WHERE revenue < 200000; SELECT * FROM clients WHERE revenue > 200000; SELECT * FROM clients WHERE revenue = 200000;SELECT * FROM clients WHERE revenue <= 200000;

The '<' operator is used to filter rows where the 'revenue' column has a value less than 200000.

Q30

Multiple Choice

Which SQL query correctly retrieves records from the 'students' table where 'marks' are greater than 80 AND less than 90?

SQL Code

SELECT *
FROM students
WHERE marks > 80
AND marks < 90;

SELECT * FROM students WHERE marks > 80 AND marks < 90; SELECT * FROM students WHERE marks >= 80 AND marks <= 90; SELECT * FROM students WHERE marks < 80;SELECT * FROM students WHERE marks > 90;

The '>' and '<' operators are used together to filter rows where 'marks' are between 80 and 90, exclusive.

MySQL Database Quiz Questions