projects-mysql-query

[miftahmfaris]

Pertanyaan :

1. Tampilkan semua Customer yang tinggal di Negara German atau Mexico
2. Tampilkan semua Product yang Harganya kurang dari 15
3. Tampilkan semua Product yang range Harganya dari 10 - 30
4. Tampilkan semua Customer yang tinggal di Europa
5. Hitung jumlah total Order Customer dengan Nama Rattlesnake Canyon Grocery
6. Tamplikan Orderan dari Federal Shipping dengan OrderDate kurang dari bulan 12
7. Tampilkan Semua Nama Barang yang dibeli oleh Save-a-lot Markets
8. Hitung total keseluruhan barang yang dibeli oleh B's Beverages
9. Hitung total pengiriman yang dilakukan oleh United Package pada bulan 8
10. Tampilkan Product dengan Category Beverages

[adityabimo29]

1. SELECT * FROM Customers WHERE country = 'Germany' OR country ='Mexico';

2. SELECT * FROM Products WHERE price < 15;

3. SELECT * FROM Products WHERE price >= 10 AND price <=30;

4. SELECT * FROM Customers WHERE country = 'Germany' OR country = 'UK' OR country='Sweden' OR country ='France' OR country='Spain' OR country ='Switzerland' OR country ='Austria' OR country ='Italy' OR country ='Portugal' OR country ='Ireland' OR country ='Belgium' OR country ='Norway' OR country ='Denmark' OR country ='Finland' OR country ='Poland';

5. SELECT COUNT(orderID) FROM Orders WHERE CustomerId = 65;

6. SELECT * FROM Orders WHERE ShipperID = 3 AND MONTH(orderDate) < 12;

7. SELECT p.ProductName FROM Orders o INNER JOIN OrderDetails od ON o.orderID = od.orderID JOIN Products p ON p.ProductID = od.ProductID WHERE o.CustomerID =71;

8. SELECT SUM(od.Quantity) FROM Orders o INNER JOIN OrderDetails od ON o.orderID = od.orderID WHERE o.CustomerID =11

9. SELECT COUNT(shipperID) FROM Orders WHERE MONTH(OrderDate) = 8 AND shipperID =2

10. SELECT * FROM Products WHERE CategoryID =1;

[hesamuhammad]

1. SELECT * FROM Customers WHERE Country='Germany' OR Country='Mexico'

2. SELECT * FROM Products WHERE Price < 15

3. SELECT * FROM Products WHERE Price BETWEEN 10 AND 30

4. SELECT * FROM Customers WHERE Country NOT IN ('Mexico', 'Canada', 'Brazil', 'Venezuela', 'USA');

5. SELECT COUNT (orderID) FROM Orders WHERE CustomerId = 65

6. SELECT * FROM Orders WHERE ShipperID = 3 AND MONTH(OrderDate) < 12

7. SELECT ProductName FROM Orders INNER JOIN OrderDetails ON Orders.orderID = OrderDetails.orderID JOIN Products ON Products.ProductID = OrderDetails.ProductID WHERE Orders.CustomerID = 71

8. SELECT SUM(OrderDetails.Quantity) FROM Orders INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID WHERE Orders.CustomerID = 11

9. SELECT COUNT(shipperID) FROM Orders WHERE MONTH(OrderDate) = 8 AND shipperID =2

10. SELECT * FROM Products WHERE CategoryID = 1

[pirman-ss]

1. SELECT * FROM [Customers] WHERE Country='Germany';

2. SELECT * FROM [Products] WHERE Price < 15;

3. SELECT * FROM [Products] WHERE Price BETWEEN 10 AND 30;

4. SELECT * FROM Customers WHERE Country IN ('Germany','UK', 'Sweden', 'France', 'Spain', 'Switzerland', 'Austria', 'Denmark', 'Belgium', 'Finland', 'Poland');

5. SELECT COUNT (orderID) FROM Orders WHERE CustomerId = 65

6. SELECT * FROM Orders LEFT JOIN Shippers ON ShipperName='Federal Shipping' AND MONTH(OrderDate)<12

7. SELECT ProductName FROM Orders INNER JOIN OrderDetails ON Orders.orderID = OrderDetails.orderID JOIN Products ON Products.ProductID = OrderDetails.ProductID WHERE Orders.CustomerID = 71

8. SELECT SUM(OrderDetails.Quantity) FROM Orders INNER JOIN OrderDetails ON Order.OrderID = OrderDetails.Order.ID WHERE Orders.CostumerID = 11

9. SELECT COUNT(ShipperID) FROM Orders WHERE MONTH(OrderDate) = 8 AND ShipperID = 2

10. SELECT * FROM Products LEFT JOIN Categories ON CategoryName='Beverages'

[rhfauzi]

1. SELECT * FROM Customers WHERE Country='Germany' OR Country='Mexico'

2. SELECT * FROM Products WHERE Price<15

3. SELECT * FROM Products WHERE Price BETWEEN 10 AND 30

4. SELECT * FROM Customers WHERE Country='Germany' AND Country='Sweden' AND Country='France' AND Country='Spain' AND Country='Italy'

5. SELECT COUNT(orderID) FROM Orders LEFT JOIN Customers ON CustomerName='Rattlesnake Canyon Grocery'

6. SELECT * FROM Orders LEFT JOIN Shippers ON ShipperName='Federal Shipping' AND MONTH(OrderDate)<12

7. SELECT p.ProductName FROM Orders o INNER JOIN OrderDetails od ON o.orderID=od.orderID JOIN Products p ON p.ProductID = od.ProductID WHERE o.CustomerName='Save-a-lot Markets';

OR

SELECT p.ProductName FROM Orders o INNER JOIN OrderDetails od ON o.orderID=od.orderID JOIN Products p ON p.ProductID = od.ProductID WHERE o.CustomerID=71;

8. SELECT SUM(od.Quantity) FROM OrderDetails od, Orders o, Customers c WHERE MONTH(o.OrderDate)<12 AND c.CustomerName="B's Beverages"

OR

SELECT SUM(od.Quantity) FROM OrderDetails od, Orders o, Customers c WHERE MONTH(o.OrderDate)<12 AND c.CustomerID=11

9. SELECT count(OrderID) FROM Orders LEFT JOIN Shippers ON ShipperName='United Package' WHERE MONTH(OrderDate)='8'

10. SELECT * FROM Products LEFT JOIN Categories ON CategoryName='Beverages'

[elindas]

1. SELECT * FROM Customers WHERE Country='Germany' OR Country='Mexico'

2. SELECT * FROM Products WHERE Price < 15

3. SELECT * FROM Products WHERE Price BETWEEN 10 AND 30

4. SELECT * FROM Customers WHERE Country!='Mexico' AND Country!='Canada' AND Country!='Argentina' AND Country!='Brazil' AND Country!='USA' AND Country!='Venezuela'

5. SELECT COUNT (orderID) FROM Orders WHERE CustomerId = 65

6. SELECT * FROM [Orders] WHERE ShipperID = 3 AND MONTH(OrderDate) < 12

7. SELECT ProductName FROM Orders INNER JOIN OrderDetails ON Orders.orderID = OrderDetails.orderID INNER JOIN Products ON Products.ProductID = OrderDetails.ProductID WHERE Orders.CustomerID = 71

8. SELECT SUM(OrderDetails.Quantity) FROM Orders INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID WHERE Orders.CustomerID = 11

9. SELECT COUNT(shipperID) FROM Orders WHERE MONTH(OrderDate) = 8 AND shipperID =2

10. SELECT * FROM Products INNER JOIN Categories ON CategoryName='Beverages'

[inanuriy]

1. SELECT * FROM Customers WHERE Country='Mexico' OR Country='Germany';

2. SELECT * FROM [Products] WHERE Price < 15

3. SELECT * FROM Products WHERE Price BETWEEN 10 AND 30;

4. SELECT * FROM [Customers] WHERE NOT Country='Mexico' AND NOT Country='Canada' AND NOT Country='Brazil' AND NOT Country='USA' AND NOT Country='Argentina';

5. SELECT COUNT(OrderID) FROM Orders LEFT JOIN Customers ON Customers.CustomerID=Orders.CustomerID WHERE CustomerName='Rattlesnake Canyon Grocery';

6. SELECT Orders.OrderDate, Shippers.ShipperName, Orders.ShipperID FROM Orders LEFT JOIN Shippers ON Orders.ShipperID=Shippers.ShipperID WHERE Shippers.ShipperName='Federal Shipping' AND NOT OrderDate LIKE '%12%';

7. SELECT Customers.CustomerName, Customers.CustomerID, Orders.CustomerID, Orders.OrderID, OrderDetails.OrderID, OrderDetails.ProductID, Products.ProductID, Products.ProductName FROM Customers LEFT JOIN Orders, OrderDetails, Products ON Customers.CustomerID=Orders.CustomerID AND Orders.OrderID=OrderDetails.OrderID AND OrderDetails.ProductID=Products.ProductID WHERE Customers.CustomerName='Save-a-lot Markets';

8. SELECT SUM(Quantity) FROM OrderDetails INNER JOIN Customers, Orders ON Orders.CustomerID=Customers.CustomerID AND Orders.OrderID=OrderDetails.OrderID WHERE Customers.CustomerName="B's Beverages"

9. SELECT COUNT(Orders.OrderDate, Shippers.ShipperName, Orders.ShipperID) FROM Orders LEFT JOIN Shippers ON Orders.ShipperID=Shippers.ShipperID WHERE Shippers.ShipperName='United Package' AND OrderDate LIKE '1996-08-%';

10. SELECT Categories.CategoryName, Categories.CategoryID, Products.ProductName, Products.CategoryID FROM Products LEFT JOIN Categories ON Categories.CategoryID=Products.CategoryID WHERE Categories.CategoryName='Beverages'

[fransjesky]

1. SELECT * FROM Customers WHERE Country='Germany' OR Country='Mexico'

2. SELECT * FROM Products WHERE Price<=15

3. SELECT * FROM Products WHERE Price>10 AND Price<30

4. SELECT FROM Customers WHERE Country='Germany' OR Country='Sweden' OR Country='UK' OR Country='France' OR Country='Spain' OR Country='Switzerland' OR Country='Austria' OR Country='Italy' OR Country='Portugal' OR Country='Ireland' OR Country='Belgium' OR Country='Norway' OR Country='Finland' SELECT FROM Customers WHERE Country='Germany' OR Country='Sweden' OR Country='UK' OR Country='France' OR Country='Spain' OR Country='Switzerland' OR Country='Austria' OR Country='Italy' OR Country='Portugal' OR Country='Ireland' OR Country='Belgium' OR Country='Norway' OR Country='Finland'

5. SELECT * FROM Customers WHERE CustomerName='Rattlesnake Canyon Grocery'; SELECT COUNT (OrderID) FROM Orders WHERE CustomerID=65;