Start a new Kumite
AllAgda (Beta)BF (Beta)CCFML (Beta)ClojureCOBOL (Beta)CoffeeScriptCommonLisp (Beta)CoqC++CrystalC#D (Beta)DartElixirElm (Beta)Erlang (Beta)Factor (Beta)Forth (Beta)Fortran (Beta)F#GoGroovyHaskellHaxe (Beta)Idris (Beta)JavaJavaScriptJulia (Beta)Kotlinλ Calculus (Beta)LeanLuaNASMNim (Beta)Objective-C (Beta)OCaml (Beta)Pascal (Beta)Perl (Beta)PHPPowerShell (Beta)Prolog (Beta)PureScript (Beta)PythonR (Beta)RacketRaku (Beta)Reason (Beta)RISC-V (Beta)RubyRustScalaShellSolidity (Beta)SQLSwiftTypeScriptVB (Beta)
Show only mine

Kumite (ko͞omiˌtā) is the practice of taking techniques learned from Kata and applying them through the act of freestyle sparring.

You can create a new kumite by providing some initial code and optionally some test cases. From there other warriors can spar with you, by enhancing, refactoring and translating your code. There is no limit to how many warriors you can spar with.

A great use for kumite is to begin an idea for a kata as one. You can collaborate with other code warriors until you have it right, then you can convert it to a kata.

Ad
Ad
pristiandewiabbyvs.rishadharis

Basic Filtering 9 OR (BIE)

Code
Diff
  • select * from transactions
where customer like 'D%' or customer like 'E%';
    • -- Code Here
    • select * from transactions
    • where customer like 'D%' or customer like 'E%';
pristiandewiabbyvs.rishadharis

Basic Use Case 1 (BIE)

Code
Diff
  • select * from employees 
where salary >= 5000000 and months >= 12
order by salary desc;
    • -- Code Here
    • select * from employees
    • where salary >= 5000000 and months >= 12
    • order by salary desc;
neetha88vs.rishadharis

Basic Use Case 2 LIMIT (BIE)

Code
Diff
  • -- Code Here
select * 
from employees
order by salary desc
limit 10
    • --- Code Here
    • -- Code Here
    • select *
    • from employees
    • order by salary desc
    • limit 10
ryanmovementvs.rishadharis

Basic Ordering 2 DESC (BIE)

Code
Diff
  • -- Code Here
SELECT
  *
FROM
  transactions
ORDER BY
  total_price DESC;
    • --- Code Here
    • -- Code Here
    • SELECT
    • *
    • FROM
    • transactions
    • ORDER BY
    • total_price DESC;
AndhikaPJvs.rishadharis

Basic Ordering 3 Multiple Order (BIE)

Code
Diff
  • -- Code Here
SELECT
  *
FROM
  transactions
WHERE
  customer IS NOT null
ORDER BY
  store ASC, total_price DESC;
    • --- Code Here
    • -- Code Here
    • SELECT
    • *
    • FROM
    • transactions
    • WHERE
    • customer IS NOT null
    • ORDER BY
    • store ASC, total_price DESC;
neetha88vs.rishadharis

Basic Filtering 6 Like (BIE)

Code
Diff
  • -- Code Here
select * 
from transactions
where customer like 'S%'
and customer like '%r'
    • --- Code Here
    • -- Code Here
    • select *
    • from transactions
    • where customer like 'S%'
    • and customer like '%r'
ryanmovementvs.rishadharis

Basic Ordering 1 ASC (BIE)

Code
Diff
  • -- Code Here
SELECT
  *
FROM
  transactions
ORDER BY
  total_price ASC;
    • --- Code Here
    • -- Code Here
    • SELECT
    • *
    • FROM
    • transactions
    • ORDER BY
    • total_price ASC;
neetha88vs.rishadharis

Basic Filtering 8 Is Not (BIE)

Code
Diff
  • -- Code Here
select *
from transactions
where customer is not null
    • --- Code Here
    • -- Code Here
    • select *
    • from transactions
    • where customer is not null
znlbdinvs.rishadharis

Basic Filtering 7 Is (BIE)

Code
Diff
  • SELECT *
FROM transactions
WHERE customer IS NULL
    • -- Code Here
    • SELECT *
    • FROM transactions
    • WHERE customer IS NULL
neetha88vs.rishadharis

Basic Filtering 5 Not In (BIE)

Code
Diff
  • -- Code Here
select * 
from  
  transactions
where store not in ('BIE Store Jakarta', 'BIE Store Bandung')
    • --- Code Here
    • -- Code Here
    • select *
    • from
    • transactions
    • where store not in ('BIE Store Jakarta', 'BIE Store Bandung')