Question

What will be the output of the query?

SELECT MACHINE ID, MACHINE NAME FROM INVENTORY WHERE QUANTITY <= 100;

Options

• All columns of INVENTORY table with quantity greater than 100.

• ID and name of machines with quantity less than 100 from INVENTORY table.

• All columns of INVENTORY table with quantity greater than or equal to 100.

• ID and name of machines with quantity less than or equal to 100 from INVENTORY table.

Answer 1

ID and name of machines with quantity less than or equal to 100 from INVENTORY table.

Explanation:

The SELECT clause specifically chooses only the MACHINE_ID and MACHINE_NAME columns, not the entire table. The WHERE clause uses the <= operator, which filters the records to include only those where the quantity is either less than or exactly equal to 100.