Write query 8. List all orders with the ordered quantity greater than a specific

Question

Write query

8. List all orders with the ordered quantity greater than a specific value (getqty). Write SQL code to
create a stored procedure and show the result when getqty=1.5 (the codes for execute the
procedure query is: SET @p0=’1.5’; CALL procedure_name (@p0))

hwquery New customer Columns New CITY CUST ID a CUST NAME STATE I STREET LI ZIPCODE Indexes T- orderline Columns New order id product id quantity Indexes ordertable -Il Columns New cust id order date order id Indexes product Column New product id product name product price Indexes

Explanation / Answer

8 . SELECT order_id FROM orderline WHERE quantity> 20 ;

for an example here i am giving quantity= 20; you can give whatever quantity you need.

********************END**********PLS GIVE ME GOOD RATING*****************************

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.