Question: According to the following tables write the necessary SQL queries: Order Table database OrderID CustomerID Order Date EmployeeID 5 ShipperID 3 90 10248 10249 10250

 According to the following tables write the necessary SQL queries: Order

According to the following tables write the necessary SQL queries: Order Table database OrderID CustomerID Order Date EmployeeID 5 ShipperID 3 90 10248 10249 10250 1996-07-04 1996-07-05 81 6 1 34 4 1996-07-08 2 10251 84 3 1996-07-08 1 10252 76 4 1996-07-09 2 10253 34 3 1996-07-10 2 Shipper Table ShipperID 1 2 ShipperName Phone Then, Speedy Express from the Customers tale (503) 555-9831 United Package (503) 555-3199 Cus Federal Shipping er Name (503) 555-9931 tactName Alfreds Futtedeste Marlies 3 Cou Customer Table : ContactName Address Maria Anders Obere Str. 57 Ana Trujillo Avda. de la Constitucin 2222 Antonio Moreno Mataderos 2312 City Berlin Mxico D.F. PostalCode Country 12209 Germany 05021 Mexico CustomerID Customer Name 1 Alfreds Futterkiste Ana Trujillo Emparedados y helados Antonio Moreno Taqueria Around the Horn 2 3 Mxico D.F. 05023 Mexico Thomas Hardy 120 Hanover Sq. London WAI 1DP UK Q1 ) Selects all records that have matching values in both tables.1.5 Marks Q2) Select all orders with customer and shipper information. 1.5 Marks Q3) Lists the number of customers in each country. Only include countries with more than 5 customers.2 Marks

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!