Question: please i need the answer of question 3 please Order Table Order Date Shippert OrderID Customer D Employee ID 1996-07-04 3 5 10248 90 1996-07-05

please i need the answer of question 3 please

Order Table Order Date Shippert OrderID Customer D Employee ID 1996-07-04 3 5 10248 90 1996-07-05 1 6 10249 81 1996-07-08 2 4 10250 34 1996-07-08 1 3 10251 94 2 1996-07-09 4 10252 76 1996-07-10 2 3 34 10253 Shipper Table Phone Shipper ID Shipper Name 1 (503) 555-9831 W Speedy Express 2 United Package (503) 555-3199 3 Federal Shipping (503) 555-9931 Customer Table Contact Name PostalCode Country City Address Customer Customer Name Berlin 12209 Germany 1 Alfreds Futterkiste Maria Anders Obere Str. 57 Mes OF 05021 Mexico 2 Ana Trujillo Ar Trilo Emparedados y helados Avda. de la Constitucin 2222 05023 Mexico Mexico DF 3 Antonio Moreno Mataderos 2312 Antonio Moreno Taqueria UN WAT IDP London Around the Horn Thomas Hardy 120 Hanover 50 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!

Suppose you are trying to classify a variable where 96% of its observations equal 0 and only 4% equal 1. You run a logistic regression, and the classification table shows that 97% of the...

Customer Table : Customer CustomerName Address City PostalCode Country According to the following tables write the necessary SQL queries: Order Table database first page OrderID Customer ID...

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...

Just answer A , B , C include your answers with screen shots of the results. Create a report containing Company names and Orders. Must use 2 tables Customers and Orders Common field is the...

Please answer with the vlookup formula needed for the "Customer Status" in Part 3 and formulas needed for Parts 4-6 (ignore parts 1-2). Part 1: ETL with the OrderId field Let's decide that the rule...

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 Data Shipper 10248 90 5 1996-07-04 3...

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...

Please answer all questions File Home Q1) Open a blank database called YouriD.accdb (e.g. 52315456.accdb). Q2) Import the Excel File (Dataset_vx.xlsx) into Access (the database you already created)....

please answer this question Lab Exercise(5%) According to the following tables write the necessary SQL queries: Order Table Employee Order ID 1024 10249 10250 Customer 90 31 Order Date 1990-01-04...

Which one of the following statements pulksal the data from the Order Details table? Me Onder Product Une te Quantity Deco 1 10000 11 14.00 12 2 10240 12 9.30 10 3 10249 72 34.80 5 0 4 10249 14 18.60...

ATTENTION TUTORS PLEASE HELP ME IN ANSWERING THIS ATTACHMENT WORKSHEET I NEED IT FOR CLASS IN ACCOUNTING THANK YOU HAVE THE ANSWERS IN YELLOW PLEASE SEE ATTACHMENT Question 1 of 15 1. A small...

Refer to Skyline Music in S12-11. What is the approximate internal rate of return (IRR) of the studio investment? In S12-11 Skyline Music is considering investing $750,000 in private lesson studios...

Identify the main types of pricing discounts offered to consumers and businesses.

4 2 5 points 4 hork nes Plet Beferencet You work for a nuclear research laboratory that is contemplating leasing a biagnontic scamner ( leasing is a common practice with expensive, high - tech...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

1. Activist federal safety agency actions include new accident reporting rules and attempts to publicize company safety records. The Occupational Health and Safety Administration (OSHA) is focused on...

LO5 List three workplace health issues and highlight how employers are responding to them.

LO6 Define workplace security concerns and discuss some elements of an effective security program.