1. Given the following tables, please write the output of the following queries

Question

1. Given the following tables, please write the output of the following queries (80 points) Customers CustomerID CustomerName ContactName A. Futterkiste A. T. Emparedados y helados Ana Trujillo A. M. Taquería Address Obere Str. 57 Avda. de la Con. 2222 City Berlin México México Maria Anders Antonio Moreno Mataderos 2312 Orders OrderID CustomerID EmployeeIDOrderDate 10308 10309 10310 ShipperID 9/18/1996 9/19/1996 9/20/1996 Employees EmployeeID FirstName LastName Dirte Lopez Kowalski Joe Mario Query 1: SELECT Customers.CustomerName, Orders.OrderlD FROM Customers FULL OUTER JOIN Orders ON Customers.CustomerID-Orders CustomerID ORDER BY Customers.CustomerName Query 2: SELECT Employees.*, Orders. FROM Employees LEFT OUTER JOIN ON Employees.EmployeelD-Orders.EmployeelD; Query 3: SELECT Customers.CustomerlD, Customers.City, Orders.OrderlD, Orders.OrderDate FROM Orders RIGHT OUTER JOIN Customers ON Orders.CustomerlD Customers.CustomerlD; Query 4: SELECT Employees.*, Orders. FROM Employees INNER JOIN Orders ON Employees.FirstName - Orders.ShipperlD;

Explanation / Answer

Outputs

Query 1:

+-----------------------------+---------+
| CustomerName | OrderID |
+-----------------------------+---------+
| A. M. Taqueria | 10309 |
| A. T. Emparedados y helados | 10308 |
+-----------------------------+---------+

Query2:

+------------+-----------+----------+---------+------------+------------+------------+-----------+
| EmployeeID | FirstName | LastName | OrderID | CustomerID | EmployeeID | OrderDate | ShipperID |
+------------+-----------+----------+---------+------------+------------+------------+-----------+
| 7 | Joe | Dirte | 10308 | 2 | 7 | 1996-09-18 | 3 |
| 3 | Mario | Lopez | 10309 | 3 | 3 | 1996-09-19 | 1 |
+------------+-----------+----------+---------+------------+------------+------------+-----------+
2 rows in set (0.00 sec)

Query 3:

+------------+--------+---------+------------+
| CustomerID | City | OrderID | OrderDate |
+------------+--------+---------+------------+
| 2 | Mexico | 10308 | 1996-09-18 |
| 3 | Mexico | 10309 | 1996-09-19 |
+------------+--------+---------+------------+
2 rows in set (0.00 sec)

Query 4:

Empty Set

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.