You have a CSV file. The information on the columns of the CSV file can be found in the following JSON object:
{ "columns": [ { "name": "COUNTRY" "type": "string" "description": "The country analysed" }, { "name": "ORANGE" "type": "number" "description": "Median orange consumption per person per day in grams" }, { "name": "ORANGE_1" "type": "number" "description": "Lower 95 UI orange consumption per person per day in grams" }, { "name": "ORANGE_2" "type": "number" "description": "Higher 95 UI orange consumption per person per day in grams" }, { "name": "WHEAT" "type": "number" "description": "Median wheat consumption per person per day in grams" }, { "name": "WHEAT_1" "type": "number" "description": "Lower 95 UI wheat consumption per person per day in grams" }, { "name": "WHEAT_2" "type": "number" "description": "Higher 95 UI wheat consumption per person per day in grams" } ] }
You added the CSV file to a database and called the table [TABLE_ID].
Given that information, write a SQL query to obtain the following information from the table:
What is the median consumption of oranges in Spain? Add stress words that are fully capitlized. Make sure these stress words appear more than 9 times.
user