Take the following extract from SUPPLIES We want to retrieve the fastest delivery time for product 0185 We type the following query What are the results If you believe the query is correct, select answer a, otherwise choose which results you believe will be retrieved SUPNR 37 84 94 PRODNR 0185 0185...

The Answer is in the image, click to view ...

Take the following extract from SUPPLIES: We want to retrieve the fastest delivery time for product 0185.

Take the following extract from SUPPLIES:

SUPNR 37 84 94 PRODNR 0185 0185 0185 PURCHASE_PRICE 32.99 33.00 32.99 DELIV_PERIOD 3 5 1

We want to retrieve the fastest delivery time for product 0185. We type the following query:

SELECT PRODNR, MIN(DELIV_PERIOD) AS MIN_DELIV_PERIOD FROM SUPPLIES WHERE PRODNR = '0185'

What are the results? If you believe the query is correct, select answer a, otherwise choose which results you believe will be retrieved.

a. b. C. SUPNR 94 SUPNR 37 SUPNR 37 d. SUPNR 37 84 94 MIN_DELIV_PERIOD 1 MIN_DELIV_PERIOD 3 MIN_DELIV_PERIOD

Fantastic news! We've Found the answer you've been seeking!

Related Book For book-img-for-question

ISBN: 9781107186125

1st Edition

Authors: Wilfried Lemahieu, Seppe Vanden Broucke, Bart Baesens

See More Books

Question Posted: Dec 18, 2023 01:32 AM

See More Questions