Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need answer for #3 E: CSC315 DData>sqlite3 northwind. db . read q4.5q1 123.46 223.44 323.61 1307/5572=23.46% 1.Following the example query to find the

image text in transcribed
i need answer for #3 image text in transcribed
E: \ CSC315 DData>sqlite3 northwind. db ". read q4.5q1" 123.46 223.44 323.61 1307/5572=23.46% 1.Following the example query to find the total number of ShipVia. sqlite> SELECT ShipVia FROM 'Order' GROUP BY ShipVia; 1 2 3 sqlite> SELECT COUNT(ShipVia) FROM 'Order' GROUP BY ShipVia; 5572 5592 5654 sqlite> Modify the example to get the same output 15572 25592 35654 sqlite> 2. The example query shows the sum of orders which are late. sqlite> SELECT COUNT(") FROM 'Order' WHERE ShippedDate > RequiredDate; 3953 sqlite> Modify the query to get the same output 11307 21311 31335 sqlite> It means there are total 1307 orders are late from ShipVia 1, 1311 orders are late from ShipVia2 3. Based on the question 1 and question 2 to get the late rate for each ShipVia E: CSC315\ Data>sq1ite3 northwind, db=.read q4.5q1 " 123.46 223.44 323.61 1307/5572=23.46%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inference Control In Statistical Databases From Theory To Practice Lncs 2316

Authors: Josep Domingo-Ferrer

2002nd Edition

3540436146, 978-3540436140

More Books

Students also viewed these Databases questions

Question

How do we organise for international logistics?

Answered: 1 week ago

Question

What are the logistics implications of internationalisation?

Answered: 1 week ago