Question: please answer this or i will fail Lab Exercise(5%) According to the following tables write the necessary SQL queries: Order Table Order Customer Employee Order

please answer this or i will fail
please answer this or i will fail Lab Exercise(5%) According to the

Lab Exercise(5%) According to the following tables write the necessary SQL queries: Order Table Order Customer Employee Order Data Shipper 10248 90 5 1996-07-04 3 10249 81 5 1996-07-05 1 10250 34 4 1996-07-06 2 10251 34 3 1996-07-08 1 10252 76 4 1996-07-09 2 10253 34 3 1996-07-10 2 Shipper Table Shipper ID Shipper Name Phone 1 Speedy Express (503) 555-9831 2 United Package (503) 555-3199 3 Federal Shipping C (503) 555-9931 Customer Table : Customer ID Customer Name Contact Name Address City Postal Code Country 1 Alfreds Futterkista Maria Anders Obere Str 52 Berlin 12209 Germany 2 Ana Trujillo Emparedados y halados Ana Tropile Mexico 05021 Mexico Avda de la Constitucin 222 3 Antonio Moreno Mataderos 2012 Mexico DF 05023 Antonio Moreno Taqueria Mexico Around the Hom Thomas Hardy 120 Hanover Sa London WA110P UK 01) 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!