Freestyle Sparring

using System.Collections.Generic;
using System.Linq;
public class Kata
{
    /// <summary>
    /// Checks if two char arrays contain at least one common item.
    /// </summary>
    /// <param name="a">First char array</param>
    /// <param name="b">Second char array</param>
    /// <returns>True if the arrays have at least one common item, false otherwise</returns>
    public static bool ContainsCommonItem(char[] a, char[] b)=>a == null || b == null ? false : a.Intersect(b).Any();
    
}

using System;

public class RomanDecode
{
  public static int GetCharacter(char character) {
    switch (character) {
        case 'I': return 1;
        case 'V': return 5;
        case 'X': return 10;
        case 'L': return 50;
        case 'C': return 100;
        case 'D': return 500;
        case 'M': return 1000;
        default: throw new NotImplementedException();
    }  
  }
  
	public static int Solution(string roman)
	{
		var result = 0;
    var lastCharacter = 0;
    for (var i = roman.Length - 1; i >= 0; i--) {
      var character = GetCharacter(roman[i]);
      if (character >= lastCharacter) {
        result += character;
      } else {
        result -= character;
      }
      lastCharacter = character;
    }
    return result;
	}
}

function addArr(arr){  
  return arr.reduce((sum, num) => sum + num, 0) || null
}

-- Code Here
select
  d.city_name as kota,
  sum(c.confirmed_cases) as confirmed_cases,
  sum(c.recovered_cases) as recovered_cases,
  sum(c.death_cases) as death_cases
from cases c
left join dati d
on d.code = c.dati_code
group by 1
order by 2 desc

def дима_лох():
    return 'w - h - y'

def should_return_1():
    a = 2 - 1
    return a

-- Code Here
SELECT * FROM employees
ORDER BY salary DESC
LIMIT 10

-- Code Here
SELECT *
FROM transactions
WHERE customer IS NOT NULL
ORDER BY store, total_price DESC

-- Code Here
SELECT*FROM transactions
order by total_price DESC;