7.Give IDs, names, and states of cities with names starting with C.

15.For each citywith population over 1 million, what is the minimum weight of a shipment sent to that city? Use city_name to identify each city. Label the minimum weight column as Min_Weight.

26. For each customer (cust_id and cust_name) with annual revenue under $10 million, and whose shipments average more than 5000 pounds, what is the total weight of shipments theyve sent? Label the total column as Total_Weight. (Hint: Requires Having.)

27. List the names and annual revenues of customers who have sent shipments weighing over 10000 pounds.

28. Which city or cities (city_name) in the database have the largest population? (HInt: Use City table twice.)

31.Give a list of customers by name, all of whose shipments weigh over 5000 pounds. (Hint: This requires a correlated subquery. Use min function and

32. List the city or cities (city_name) and their population for the cities in the database having the smallest population. (Hint: Use City table twice.)

34. List the names and annual revenues of customers whose shipments have been delivered by the truck driver whose last name is Newell. (Hint: Requires 2 subqueries.)