History for Question11

??changed:
-
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

<hr solid id=comments_below>


mj (Sep 17, 2001 8:09 pm; Comment #1)  --
 Last one I'll do.