Please use PHPMYADMIN to answer this questions CUSTOMER Phone should keep the da

Question

Please use PHPMYADMIN to answer this questions

CUSTOMER Phone should keep the dashes Country+ Canada United States Germany Australia United States Phone 555-9888 555-8184+ 833-8483 842-4850+ 110-9493 CustomerlD Name Mitch Connore Professor Chaos Al Gorep Jerry Seinfeld Bruce Wayne 2p 3p 5P ORDERS PartID 72 OrderID 10308v 1030% 10310- 10311+ CustomerlD 50 2p ShippingDate 2015-09-12 2014-12-01+ 2016-04-22' 2016-08-18 90P 26 50 STOCK PartID 11p 26 72 90P 109 PartName Beer Wrench+ Scotchp Drillv Benche Quantityo 72 12 34P 62

Explanation / Answer

SELECT name,phone FROM CUSTOMER WHERE Country = "United States";

SELECT PartName, PartID FROM Stock WHERE Quantity < 40;

SELECT SUM(Quantity) FROM Stock;

**Comment for any further queries.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---