Use the % modulus operator and a lot of ingenuity to show how big each country is relative to Wales

Query_Sol. for MySQL users

SELECT 
    Country,
    KmSquared,

/* In MySQL, you can use the 'DIV' to perform integer division in a SELECT statement */
    (KmSquared DIV 20761) AS WalesUnits,

/* To find the remainder of division use '%' (modulo) operator. Ex: 10 % 3 is 1 */
    (KmSquared % 20761) AS AreaLeftOver,
    
    CASE
        WHEN
            (KmSquared DIV 20761) > 0
        THEN
            CONCAT((KmSquared DIV 20761),' x Wales plus ',(KmSquared % 20761),' sq. km.')
        ELSE 'Smaller than Wales'
    END AS WalesComparison
FROM
    countriesbyarea

/* Important: To sort column by the specific nearest values to the specific value 
use 'ABS(column_name - target_value)' */
ORDER BY ABS(KmSquared - 20761);

SELECT Country, 
KmSquared,
KmSquared/20761 as WalesUnits,
(KmSquared)-(KmSquared/20761)*20761 as AreaLeftOver,
CASE    
        WHEN KmSquared < 20761 THEN 'Smaller than Wales'
  ELSE
        CONCAT(
KmSquared/20761, 'x', ' Wales Plus ',' ' ,
(KmSquared)-(KmSquared/20761)*20761 ,' ','Sq.km'
                       ) 

END as WalesComparision

FROM CountriesByArea
ORDER BY ABS(20761-KmSquared) ASC

SELECT Country,
        KmSquared,
        KmSquared % 20761 AS AreaLeftOver,
        (KmSquared - (KmSquared % 20761))/20761 AS WalesUnits,
        CONCAT((KmSquared - (KmSquared % 20761))/20761, ' x Wales plus ', KmSquared % 20761, ' sq. km.') AS WalesComparison
FROM CountriesByArea
ORDER BY ABS(20761 - KmSquared) ASC

In the SQL script used to design and fill the CountriesByArea table, there is no entry for Wales.

--SPOILER--

ANSWER:

SELECT
Country
, KmSquared
, ROUND(KmSquared/20761, 0) as 'WalesUnits'
, (Kmsquared % 20761) as 'AreaLeftOver'
, CASE 
            WHEN 
                      CAST(ROUND((KmSquared/20761), 0) as varchar(10)) < 1 
            THEN 
                      'Smaller than Wales'
            ELSE 
                      CAST(ROUND((KmSquared/20761), 0) as VARCHAR(10)) +  ' x '  +  ' Wales plus ' + 
                      CAST( (KmSquared % 20761) as VARCHAR(10)) + ' sq. km.' 
             END as 'Wales Comparison'
FROM
CountriesByArea
Order By ABS(KmSquared - 20761)

if i have array of numbers

10, 9.8, 10.1, 9.5, 10.8, 9.7

I would like to arrange this array by nearest to 10.

To compare this array to 10. I am going to subtract array values from 10:

(10-10), (10 - 9.8), (10-10.1), (10-9.5), (10-10.8), (10-9.7)

0, 0.2, -0.1, 0.5, -0.8, 0.3

To compare numbers i have to consider both postives and negatives, so i am going to use absolute values 

0, 0.2, 0.1, 0.5, 0.8, 0.3

Now let's arrange these numbers nearest to 10:

0, 0.1, 0.2, 0.3, 0.5, 0.8

Now write down with corresponding numbers:

10, 10.1, 9.8, 9.7, 9.5, 10.8

So to summarize, i arranged numbers by using ABS(MyNumbers - 10)

I managed to get until the last part but still when sorting the results as requested the are two countries misssing, any ideas on the tweak that needs to be done to the query to get these two counties listed?

SELECT Country
,KmSquared
,ABS(KmSquared/20761) AS WalesUnits
,ABS(KmSquared)-((KmSquared/20761)*20761) AS AreaLeftOver
,CASE
WHEN KmSquared > 20761 THEN CAST(KmSquared/20761 AS VARCHAR(20)) 
+ ' x ' + 'Wales plus' + ' ' + CAST((KmSquared)-((KmSquared/20761)*20761
) AS VARCHAR(25)) + ' ' + 'sq. km.'
WHEN KmSquared <= 20761 THEN 'Smaller than Wales' 
END AS WalesComparison
FROM CountriesByArea
WHERE kmSquared <= ALL (SELECT KmSquared 
FROM CountriesByArea
WHERE ABS(20761 - KmSquared) < 500)

Can anyone help me with the query for text description of how many times each country could accommodate Wales?

I could solve till the second last requirement. The final one seems tough .... can anyone help with the trick?