517258 SQL - Need to extract top three cities by pop per area code.

I have a database of information including the following:

Area Code, City, State, Population, Zip

for every zip code in the USA

I need to have the following information extracted from it. For each Area Code I need to have the top three cities by population extracted with the following information:

Area Code, City, State, Population, CL URL

IMPORTANT: The data is given by zip codes so there is a population size or record for each zip code so you might have 20 zip code records for New York with a separate population size for each so this would have to be combined (to form just one New York) to get an accurate top three list. I have attached an example of the data.

Also note that I need a corresponding Craigslist URL for each entry. This can be extracted from [url removed, login to view] but the url I need is the posting one. So click the city and click the post button and you will see the url.

Programmer must not give or keep the data given to them for this project. I need the data back in delimited format.

Beceriler: Her şey Kabul, PHP, SQL

Daha fazlasını gör: top codes, sql data entry form, sql database programmer, programmer sql, php sql programmer, new york post, code top, three form, php programmer in usa, top programmer, top list, database population, php pop form, usa city state, state code, city state zip codes, state cities, extract records, can keep record database, city state zip code, sql database size, posting craigslist php, city state list database, usa city state list, project extract information

İşveren Hakkında:
( 15 değerlendirme ) Tampa, United States

Proje NO: #2263191



I can do this task perfectly.

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)