please solve part a,b,c. Thank you!

Consider the following 3 tables below. Salesperson Customer ID Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 ID Name City Industry Type 4 Samsonic pleasant J 6 Panasung gaktown J 7 Samony jackson B 9 Orange Jackson B 5 Chris 34 40000 7 Dan 41 52000 8 Ken 57 115000 11 Joe 38 38000 Orders Number order. date cust.id salesperson id Amount 8/2/96 540 10 4 2 20 1/30/99 4 8 1800 30 7/14/95 9 1 460 40 1/29/98 7 2 2400 50 2/3/98 16 7 600 60 3/2/98 6 7 720 70 5/6/98 9 7 150 a) Write SQL query to find the customers from the city 'iackson'. Write SQL query in the box below (Text Format Only) (1 Marks] b) Write SQL query to sort the orders table by Order date ascending first and then by amount descending Write SQL query in the box below (Text Format Only) [2 marks] c) Write SQL query to find the total amount of spending done by each customer by cust.id from the Orders table (Hint: GROUP BY is needed here). Write SQL query in the box below (Text Format Only) [2 marks]