Based on the table description and SQL shown, which query finds the description and price of the items that have a Price field value greater than Wireless charger, ItemNum W208? Items (ItemNum, Description, OnHand, Category, Storehouse, Price )
A)SELECT Description, Price FROM Items WHERE Price (SELECT Price FROM Items WHERE ItemNum = 'W208');
B)SELECT Description, Price FROM Items WHERE Price ItemNum = 'W208');
C)SELECT Price FROM Items WHERE ItemNum 'W208' (SELECT Description, Price FROM Items);
D)SELECT Description, Price FROM Items WHERE Price (SELECT ItemNum = 'W208' FROM Items);

Question

Based on the table description and SQL shown, which query finds the description and price of the items that have a Price field value greater than Wireless charger, ItemNum W208? Items (ItemNum, Description, OnHand, Category, Storehouse, Price )
A)SELECT Description, Price FROM Items WHERE Price >(SELECT Price FROM Items WHERE ItemNum = 'W208');
B)SELECT Description, Price FROM Items WHERE Price > ItemNum = 'W208');
C)SELECT Price FROM Items WHERE ItemNum > 'W208' (SELECT Description, Price FROM Items);
D)SELECT Description, Price FROM Items WHERE Price > (SELECT ItemNum = 'W208' FROM Items);

Quizplus · Accepted Answer

The correct query uses a subquery to find the price of the item with ItemNum 'W208' and then selects the description and price of items with a price greater than that. Option A correctly implements this logic.

Based on the Table Description and SQL Shown, Which Query