Millennium Interview Question

How would you make a GET request with a SQL query that returns JSON, and then parse the JSON to extract certain information?