Merging text with ||
You can concatenate text using the || operator in SQLite. Other databases use the CONCAT() function, but it's not availiable in this RDBMS
Show the capital of each country. For example "The capital of France is Paris".
SELECT 'The capital of ' || name || ' is ' || capital FROM world