Based on the table structure (not data) of the PVFC tables presented, write a query to answer the following question: For each customer, show the customer id, the number of orders he/she has placed, and the date of his/her latest order. Display the one with largest number of orders first.

B 

Order_T OrderLine_T OrderiD ProductiD OrderedQuantitv OrderlD CustomerID OrderDate 1001 2 1001 1 2010-10-21 1001 2 1002 8 2010-10-21 1001 4 1 1003 15 2010-10-22 1002 3 5 1004 2010-10-22 1003 3 3 1005 3 2010-10-24 1004 6 2 1006 2 2010-10-24 1004 8 2 1007 11 2010-10-27 1005 4 3 1008 12 2010-10-30 1006 4 1 1009 4 2010-11-05 1006 5 2 1010 1 2010-11-05 1006 7 2 1007 1 3 Employee_T 1007 2 2 1008 3 3 EmploveelD EmploveeName EmploveeSupervisor 1008 8 123-44-345 Jim Jason 454-56-768 1009 4 2 454-56-768 Robert Lewis 1009 3 1010 8 10 Product_T ProductID ProductLineiD ProductDescription ProductFinish ProductStandardPrice 1 1 End Table Cherry 175.00 2 Coffee Table Natural Ash 200.00 Computer Desk Entertainment Center Natural Maple 650.00 2 Natural Ash 375.00 4 3 1 Writers Desk Cherry 325.00 6. 8-Drawer Desk White Ash 750.00 2 Dining Table Natural Ash 800.00 8 3 Computer Desk Walnut 250.00