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


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
Get step-by-step solutions from verified subject matter experts
