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 PartName, Quantity FROM STOCK WHERE PartID IN
(SELECT PartID FROM ORDERS WHERE OrderID = 10309);

SELECT name, country, phone FROM Customer WHERE CustomerID IN
(SELECT CustomerID FROM ORDERS WHERE PartID IN
(SELECT PartID FROM STOCK WHERE Quantity > 40)
);

**Comment for any further queries.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---