Table: cdi_scores
Columns: country
rank
aid
trade
investment
migration
environment
security
technology
overall_average

Question: What country has a 5.5 mark for security?
SQL: SELECT "rank" FROM cdi_scores WHERE "security" = '5.5'

Question: How many times is denmark ranked in technology?
SQL: SELECT COUNT("technology") FROM cdi_scores WHERE "rank" = 'Denmark'

Question: What is the environment rating of the country with an overall average rating of 4.7?
SQL: SELECT "environment" FROM cdi_scores WHERE "overall_average" = '4.7'

Question: What is the migration rating when trade is 5.7?
SQL: SELECT "migration" FROM cdi_scores WHERE "trade" = '5.7'