Question: Write the OUTPUT of the following SQL Statement: 1- SELECT brand FROM products WHERE price = 2.2; Answer _______________________________________________________________________________________________ 2 - SELECT product_name FROM products

Write the OUTPUT of the following SQL Statement:
1- SELECT brand FROM products WHERE price = 2.2;
Answer
_______________________________________________________________________________________________
2 - SELECT product_name FROM products WHERE product_name like '%Ma%'
Answer
_______________________________________________________________________________________________
3 - SELECT price * 2 FROM products WHERE product_id = 111
Answer
_______________________________________________________________________________________________
4 - SELECT unit FROM products WHERE supplier_id = 'S3' and Category_id ='C1'
 Write the OUTPUT of the following SQL Statement: 1- SELECT brand

Use the table below to find the output PRODUCT_ID PRODUCT_NAME BRAND UNIT PRICE SUPPLIER_ID CATEGORY_ID Atlas Pieces 5 $1 Note Book 113 Box Fanta 43 114 S3 Sticky Note Paper Clips 5 Nizwa C1 117 Packet S4 Double A Ream 2 A4 Paper 51 Packet Atlas 1.7 S2 112 C1 Plastic envelope White Board Marker Pentel Box 2.2 S3 115 Pieces 1 54 C1 116 Nizwa Stapler Small Write the OUTPUT of the following SQL Statement: 1. SELECT brand FROM products WHERE price = 2.2

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!