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.

### Basic Ordering 2 DESC (BIE)

Code
Diff
• ``````select * from transactions
order by total_price desc;``````
• -- Code Here
• select * from transactions
• order by total_price desc;

### Basic Ordering 1 ASC (BIE)

Code
Diff
• ``select * from transactions order by total_price ``
• -- Code Here
• select * from transactions order by total_price

### 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;

### Basic Filtering 6 Like (BIE)

Code
Diff
• ``````select * from transactions
where customer like 'S%r';``````
• -- Code Here
• select * from transactions
• where customer like 'S%r';

### Basic Filtering 7 Is (BIE)

Code
Diff
• ``````select
*
from transactions
where
customer is null;``````
• -- Code Here
• select
• *
• from transactions
• where
• customer is null;

### Basic Filtering 5 Not In (BIE)

Code
Diff
• ``````SELECT
*
FROM
transactions
WHERE
store NOT IN ('BIE Store Jakarta', 'BIE Store Bandung');``````
• -- Code Here
• SELECT
• *
• FROM
• transactions
• WHERE
• store NOT IN ('BIE Store Jakarta', 'BIE Store Bandung');

### Basic Filtering 4 In (BIE)

Code
Diff
• ``````SELECT*FROM transactions

WHERE store IN ('BIE Store Bandung','BIE Store Palembang','BIE Store Malang')``````
• -- Code Here
• SELECT*FROM transactions
• WHERE store IN ('BIE Store Bandung','BIE Store Palembang','BIE Store Malang')

### Basic Filtering 3 (BIE)

Code
Diff
• ``````select date, store, total_price
from transactions
where date between '2022-01-01' and '2022-01-03'
``````
• -- Code Here
• select date, store, total_price
• from transactions
• where date between '2022-01-01' and '2022-01-03'

### Basic Filtering 2 AND and Relational Condition (BIE)

Code
Diff
• ``````SELECT*FROM transactions
WHERE store='BIE Store Bandung' and total_price<= 100000;``````
• -- Code Here
• SELECT*FROM transactions
• WHERE store='BIE Store Bandung' and total_price<= 100000;

### Basic Filtering 1 (BIE)

Code
Diff
• ``````-- Code here
SELECT id, name, age, kota FROM customers WHERE kota = 'Tasikmalaya'``````
• --- Code here
• -- Code here
• SELECT id, name, age, kota FROM customers WHERE kota = 'Tasikmalaya'