PLEASE ANSWER QUESTION 3 ASAP

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 \begin{tabular}{l|l} 1 & 5572 \\ 2 & 5592 \\ 3 & 5654 \\ sqlite> \end{tabular} 2.The example query shows the sum of orders which are late. sqlite> SELECT COUNT(*) FROM 'Order' WHERE ShippedDate > RequiredDate; 3953 sqlite> 5qlite> SELECT COUNT(*) FROM 'Order' WHERE ShippedDate > RequiredDate; 3953 sqlite> Modify the query to get the same output 123sqlite>130713111335 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>sqlite3northwind.db".readq4.sql"123.46223.44323.611307/5572=23.46%