IST210 LAB4

IST210 LAB4 - 574 1685.00 201 503 1876.00 202 524 1979.00...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
#1 Input SELECT PRODUCT_ID FROM demo_price WHERE END_DATE IS NULL; Output 100860 100861 100870 100871 100890 101860 101863 102130 102132 102134 102136 103120 103121 103130 103131 103140 103141 104350 104351 104352 104360 104361 104362 105123 105124 105125 105126 105127 105128 200376 200380 #2 Input SELECT CUSTOMER_ID , NAME , CITY FROM demo_customer WHERE SALESPERSON_ID = 7844 ORDER BY STATE ; Output CUSTOMER_ID NAME CITY 100 JOCKSPORTS BELMONT 105 K + T SPORTS SANTA CLARA #3 Input SELECT CUSTOMER_ID , ORDER_ID , TOTAL FROM demo_sales_order WHERE CUSTOMER_ID between 200 and 205 ORDER BY TOTAL ;
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Output CUSTOMER_ID ORDER_ID TOTAL 202 567 200.00 204 501 216.00 204 554 282.80 201 520 341.60 203 541 400.00 203 512 428.00 202 502 500.00 202 511 647.00 202 570 663.60 205 548 666.90 204 537 672.90 201 575 684.00 204 538 741.00 201 517 784.00 204 535 810.00 202 540 861.20 204 563 889.00 204 564 898.80 201 519 955.00 202 547 984.40 202 571 1095.60 204 568 1217.40 203 529 1264.70 203 532 1295.40 202 539 1300.00 204 504 1434.70 201 573 1627.00 201
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 574 1685.00 201 503 1876.00 202 524 1979.00 203 562 2044.50 201 576 2058.90 205 569 2073.00 204 578 2275.60 205 550 2356.00 202 544 2358.00 204 522 2578.80 201 518 2932.50 204 527 3054.40 201 566 3389.20 #4 Input SELECT NAME FROM demo_customer WHERE NAME LIKE '%AND%' ; Output NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER AL AND BOB'S SPORTS HIT, THROW, AND RUN WHEELS AND DEALS BOB'S SWIM, CYCLE, AND RUN #5 Input SELECT SUM ( TOTAL ) FROM demo_ITEM WHERE ORDER_ID = 503 ; Output 1876.00 #6 Input SELECT Max ( SALARY ) AS MAX_SALARY FROM demo_employee ; SELECT Min ( SALARY ) AS MIN_SALARY FROM demo_employee ; SELECT Count ( EMPLOYEE_ID ) AS NUM_EMP FROM demo_employee WHERE DEPARTMENT_ID = 30 ; Output...
View Full Document

Page1 / 3

IST210 LAB4 - 574 1685.00 201 503 1876.00 202 524 1979.00...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online