Question: Use the products table to answer this question: Products Tables PRODUCT ID PRODUCT NAME BRAND UNIT PRICE SUPPLIER_ID CATEGORY_ID 113 Note Book Atlas Pieces 5

 Use the products table to answer this question: Products Tables PRODUCT

Use the products table to answer this question: Products Tables PRODUCT ID PRODUCT NAME BRAND UNIT PRICE SUPPLIER_ID CATEGORY_ID 113 Note Book Atlas Pieces 5 51 C1 114 Sticky Note Fanta Box 4.3 S3 C1 117 Paper Clips Nizwa Packet 5 $4 C1 111 A4 Paper Double A Ream 2 51 112 Plastic envelope Atlas Packet 1.7 S2 C1 115 White Board Marker Pentel Box 2.2 S3 C2 116 Stapler Small Nizwa Pieces 1 S4 C1 SELECT name, as product name and unit FROM products WHERE pname like '&r' || price

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!