Question: 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

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

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

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!