DB Quacks SQL Tutorial · Chapter 3
JSON and the Amazing Technicolor Dreamcoat
Tech-savvy beaver swims up with a tablet. Greetings! Our pond location data is stored in modern JSON format instead of CSV. JSON handles complex, nested information beautifully! Can you read this JSON file directly?
Your task
Read and display specific fields from the external JSON file 'data/pond_locations.json'. Show the pond_id, pond_name, capacity, water_type, and depth_meters fields. You will be working with a JSON file containing pond location data.