You are maintaining data for its products in the Products table - and you want to see those products - which are 50 items that is currentStock or more than 50 but less than the minimum stock limit of items. The structure of the Products table is: ProductID - ProductName - CurrentStock - MinimumStock Two possible queries are: (a)select * from products where currentStock > MinimumStock + 50 (b)select * from products where currentStock - 50 > MinimumStock

🎲 Try a Random Question  |  Total Questions in Quiz: 84  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
ASP.NET with SQL Server Test — practice the complete quiz, review flashcards, or try a random question.

Practice this Upwork Skill Test. Freelancers take skill tests on Upwork to show their skills to potential clients and to make themselves more marketable. Upwork suggests you take as many tests as you want -  your skills are shown on your Upwork profile page.


You are maintaining data for its products in the Products table - and you want to see those products - which are 50 items that is currentStock or more than 50 but less than the minimum stock limit of items. The structure of the Products table is: ProductID - ProductName - CurrentStock - MinimumStock Two possible queries are: (a)select * from products where currentStock > MinimumStock + 50 (b)select * from products where currentStock - 50 > MinimumStock