In Database Design and Concepts, how would I create a query that lists ORDNO and MONTH for all orders in the ORDER table. Then how should I sort the results by ORDNO in descending order Order numbers...


In Database Design and Concepts, how would I create a query that lists ORDNO and MONTH for all orders in the ORDER table.  Then how should I sort the results by ORDNO in descending order  Order numbers start at 1011 and end with 1029.


The month of JANUARY is for order numbers 1011 through 1016.  The month of FEBRUARY is for order numbers 1017 through 1021. The Month of MARCH is for order numbers 1022 through to 1024.  The month of APRIL only has 1 order #1025.  The month of MAY only has 1 order#1026.  The month of JUNE has order numbers 1027 through 1029.



Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here