Question

Solving the following using this table. ORDERLINE TABLE order_id product_id quantity 1001 101 2 1001 102 2 1001 104 1 1002 103 5 1003 103 3 1004 106 2 1004 108 2 1005 104 4 1006 104 1 1006 105 2 1006 107 2 1007 102 2 1008 103 3 1008 109 3 1009 104 2 1009 107 3 1010 108 10 This table contains orders with product and quantity ordered. Fill in the following blanks to complete SQL Queries that do the following: List each product_id and order_id when the corresponding records have quantity greater than 5. ____ order_id, product_id orderlinetable WHERE > 5

          Solving the following using this table.
ORDERLINE TABLE
order_id product_id quantity
1001 101 2
1001 102 2
1001 104 1
1002 103 5
1003 103 3
1004 106 2
1004 108 2
1005 104 4
1006 104 1
1006 105 2
1006 107 2
1007 102 2
1008 103 3
1008 109 3
1009 104 2
1009 107 3
1010 108 10
This table contains orders with product and quantity ordered.
Fill in the following blanks to complete SQL Queries that do the following: List each product_id and order_id when the corresponding records have quantity greater than 5.
____ order_id, product_id
____ orderlinetable
WHERE ____ > 5

Solving the following using this table.
ORDERLINE TABLE
orderid productid quantity
1001 101 2
1001 102 2
1001 104 1
1002 103 5
1003 103 3
1004 106 2
1004 108 2
1005 104 4
1006 104 1
1006 105 2
1006 107 2
1007 102 2
1008 103 3
1008 109 3
1009 104 2
1009 107 3
1010 108 10
This table contains orders with product and quantity ordered.
Fill in the following blanks to complete SQL Queries that do the following: List each productid and orderid when the corresponding records have quantity greater than 5.
orderid, productid
orderlinetable
WHERE > 5

Added by Mar-A C.

Question

Please give Ace some feedback