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.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here