What are the employees responsible for a sale (last name only), the ID of the order, the shipping name, shipping country, and shipping fee for orders placed to ship to customers in the UK and Ireland?
MyWebSQL Localhost MySQL - MySQL Community Server (GPL) 5.6.48-log Logged in as: cis23xstudent@localhost version 3.7 Database Objects Data Tools Information Interface Help Logout Northwind B Create Table... Data for Orders Messages Information History Table Create View... # OrderID CustomerID ShipName 1 10248 VINET Vins et alcools Chevalier C {} Create Stored Procedure... CI foo Create Function... Create Trigger... EmployeeID Order Date RequiredDate ShippedDate ShipVia Freight 5 1996-07-04 00:00:00 1996-08-01 00:00:00 1996-07-16 00:00:00 3 32.3800 6 1996-07-05 00:00:00 1996-08-16 00:00:00 1996-07-10 00:00:00 1 11.6100 4 1996-07-08 00:00:00 1996-08-05 00:00:00 1996-07-12 00:00:00 2 65.8300 2 10249 TOMSP Toms Spezialitten 3 10250 HANAR Hanari Carnes 4 1 41.3400 Victuailles en stock 10251 VICTE 10252 SUPRD 5 3 1996-07-08 00:00:00 1996-08-05 00:00:00 1996-07-15 00:00:00 4 1996-07-09 00:00:00 1996-08-06 00:00:00 1996-07-11 00:00:00 3 1996-07-10 00:00:00 1996-07-24 00:00:00 1996-07-16 00:00:00 2 51.3000 Suprmes dlices 6 10253 HANAR 2 58.1700 Hanari Carnes ShipAddress 59 rue de l'Abbaye Luisenstr. 48 Rua do Pao, 67 2, rue du Commerce Boulevard Tirou, 255 Rua do Pao, 67 Hauptstr. 31 Starenweg 5 Rua do Mercado, 12 Carrera 22 con Ave. Carlos Soublette #8-35 Kirchgasse 6 Sierras de Granada 9993 Mehrheimerstr. 369 7 0 O Create Event... Products Shippers Suppliers Er Views 0 {} Procedures 0 fou Functions o E Triggers 0 B Events 0 10254 CHOPS 8 10255 RICSU 5 1996-07-11 00:00:00 1996-08-08 00:00:00 1996-07-23 00:00:00 9 1996-07-12 00:00:00 1996-08-09 00:00:00 1996-07-15 00:00:00 3 1996-07-15 00:00:00 1996-08-12 00:00:00 1996-07-17 00:00:00 2 22.9800 Chop-suey Chinese 3 148.3300 Richter Supermarkt 213.9700 Wellington Importadora 3 81.9100 HILARION-Abastos 9 10256 WELLI 10 10257 HILAA 4 1996-07-16 00:00:00 1996-08-13 00:00:00 1996-07-22 00:00:00 11 C 10258 ERNSH 1 140.5100 Ernst Handel 1 1996-07-17 00:00:00 1996-08-14 00:00:00 1996-07-23 00:00:00 4 1996-07-18 00:00:00 1996-08-15 00:00:00 1996-07-25 00:00:00 12 O 10259 CENTC 3 3.2500 Centro comercial Moctezuma 13 10260 OTTIK 1 55.0900 Ottilies Kseladen 14 0 10261 QUEDE 2 3.0500 Que Delcia Rua da Panificadora, 12 4 1996-07-19 00:00:00 1996-08-16 00:00:00 1996-07-29 00:00:00 4 1996-07-19 00:00:00 1996-08-16 00:00:00 1996-07-30 00:00:00 8 1996-07-22 00:00:00 1996-08-19 00:00:00 1996-07-25 00:00:00 9 1996-07-23 00:00:00 1996-08-20 00:00:00 1996-07-31 00:00:00 15 10262 RATTC 2817 Milton Dr. 3 48.2900 Rattlesnake Canyon Grocery 3 146.0600 Ernst Handel 16 10263 ERNSH Kirchgasse 6 830 record(s) 0.43 ms Showing records 1 - 100 Results page: Previous 1 Next SQL Editor SQL Editor 2 SQL Editor 3 + Add Record Query Query All 1 2 3 4 SELECT e. LastName, o. OrderID, o. ShipName, o.ShipCountry, o.Freight FROM Employees AS e INNER JOIN Orders AS O ON e. EmployeeID = o. EmployeeID INNER JOIN Customers AS c ON c. CustomerID = o. Customer ID WHERE o. ShipCountry = 'UK' AND O. ShipCountry = 'Ireland'; 5 6 7 8 9 10 Type to filter object list
