Question: SQL PHP I'm working on MyphpAdmin so I'm working on sql coding Q4: Display the IDs and names of the board products whose prices are

SQL PHP

I'm working on MyphpAdmin

SQL PHP I'm working on MyphpAdmin so I'm working on sql codingQ4: Display the IDs and names of the board products whose prices

so I'm working on sql coding

Q4: Display the IDs and names of the board products whose prices are below 1000.

SELECT `PRO_ID`, `PRO_NAME`

FROM `products`

WHERE `PRO_PRICE`

AND `PRO_NAME` LIKE `%Board%`

---

it doesn't run, error in last line.

Q7: Display the information of the products whose prices are above 500 produced by iBall.

SELECT `PRO_ID`, `PRO_NAME`, `PRO_PRICE`, `PRO_COM`

FROM `products`

WHERE `PRO_PRICE` >500

AND `COM_NAME` =`iBall`;

Same error in last line,

---------------------

How many records are there in the results of the following queries? Give and explain your answers without running the queries. 1.1. SELECT * FROM orders, customer

Sort & Filter Records products companies PRO ID PRO NAME PRO PRICE PRO COM Click to Add 101 Mother Board 102 Key Board 103 ZIP drive 104 Speaker 105 Monitor 106 DVD drive 107 CD drive 108 Printer 109 Refill cartridge 110 Mouse 3200 450 250 550 5000 900 800 2600 350 250 0 15 16 14 16 12 12 13 13 12 0

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!