Question11

Question 11

Update the quantity for p06 and p07 to 90000. Now write a query that will return the pid and pname for all PRODUCTS whose quantity on hand is less than the reorder number. The column title should be: PID NAME Percent Of Reorder where this column is the QUANTITY divided by REORDER. Arrange the output in ascending order by pname.

SQL:

    update product
        set quantity = 90000
        where pid in ('p06', 'p07');

    select pid, pname, (DOUBLE(quantity)/DOUBLE(reorder)) as "Percent Of Reorder"
        from product
        where quantity < reorder
        order by pname;

Output:

    p07 case    0.9
    p06 folder  0.9

mj (Sep 17, 2001 8:09 pm; Comment #1)

Last one I'll do.