Post a Contest

Facebook Query Language (FQL) Report

Status: Closed
Prize: $100
Entries Received: 3

Contest Brief

** IMPORTANT: To bid on this, you MUST have successfully have a solution AND POST 3 lines from the report as a comment with your bid. Any bids that DO NOT have this will be denied/banned. This is a high-priority project and I am offering $100 to the first person to provide a winning solution.

I need a list of all Job Titles (example: Web Developer, Welder, Mechanic, Pilot) facebook allows for individual users to have, ranked by size and who live in the United States. I think this can be done with FQL (Facebook Query Language). You need to post 3 lines from your report to demonstrate you know how to do this. Final report to me will be in Excel.

An example using SQL would be: SELECT job_titles, FROM table_name, COUNT, SORT BY job_title

Example of report should look something like:

//START OF REPORT
Cashier 4,203,0233 users
Janitor 4,200,321 users
Accounting 4,002,420 users
Cleaner 3,203,043 users
....
...
...
...
//END

Each count equals users with same job title. So if only 5 facebook profiles in United States list "Car Sales Detailer" then that line in the report should read: Car Sales Detailer 5 users

Recommended Skills

Post a Contest Like This

Public Clarification Board

bksingh2187
- 11 years ago
SELECT metric, value FROM insights WHERE metric=’job_titles’ count, sort by metric
- 11 years ago
akhter1987
- 11 years ago
FQL can't let you gather all facebook information freely
- 11 years ago
tsonevpetko
- 11 years ago
You cannot run FQL queries the way you want.
- 11 years ago
tsonevpetko
- 11 years ago
It doesn't work like this
- 11 years ago