Chapter 3, Problem 4.3CP

Produce a list of each customer number and the third and fourth digits of his or her zip code. The query should also display the position of the first occurrence of a 3 in the customer number, if it exists.

The tblCities table contains a numeric field named Population. Which of the following LINQ statements calculates the total population of all the cities in the table?a. Dim intTotal As Integer =            Aggregate city In CitiesDataSet.tblCities           Select city.Population Into Sum()b. Dim intTotal As Integer =            Sum city In CitiesDataSet.tblCities            Select city.Population Into totalc. Dim intTotal As Integer =           Aggregate CitiesDataSet.tblCities.city           Select city.Population Into Sum()d. Dim intTotal As Integer =            Sum city            In CitiesDataSet.tblCities.population

Please help with this SQL assignment: StarsIn (movieTitle: string, movieYear: string, starName: string MovieStar(name: string, address: string, gender: char, birthdate: date) MovieExec(name: string, address: string, CERT#: int, netWorth: int) SELECT movieTitle FROM StarsIn, MovieStar WHERE starName = name AND birthdate = 1950 Translate to relational algebra.