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
rapikarosaliavs.rishadharis

Basic Filtering 6 Like (BIE)

Code
Diff
  • -- Code Here
SELECT*FROM transactions
WHERE customer LIKE 'S%r';
    • --- Code Here
    • -- Code Here
    • SELECT*FROM transactions
    • WHERE customer LIKE 'S%r';
pristiandewiabbyvs.rishadharis

Basic Filtering 8 Is Not (BIE)

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

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')
    • -- Code Here
diakurniavs.rishadharis

Basic Filtering 4 In (BIE)

Code
Diff
  • -- Code Here
SELECT *
FROM TRANSACTIONS 
WHERE store IN ('BIE Store Bandung','BIE Store Malang','BIE Store Palembang')
    • --- Code Here
    • -- Code Here
    • SELECT *
    • FROM TRANSACTIONS
    • WHERE store IN ('BIE Store Bandung','BIE Store Malang','BIE Store Palembang')
pristiandewiabbyvs.rishadharis

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';
RHEZADarvs.rishadharis

Basic Filtering 2 AND and Relational Condition (BIE)

Code
Diff
  • -- Code Here
select *
from transactions
where store like 'BIE Store Bandung'
and
total_price <= 100000
    • --- Code Here
    • -- Code Here
    • select *
    • from transactions
    • where store like 'BIE Store Bandung'
    • and
    • total_price <= 100000
rapikarosaliavs.rishadharis

Basic Filtering 1 (BIE)

Code
Diff
  • SELECT*FROM customers
WHERE kota = 'Tasikmalaya';
    • -- Code here
    • SELECT*FROM customers
    • WHERE kota = 'Tasikmalaya';
ryanmovementvs.rishadharis

Basic Select with Alias (BIE)

Code
Diff
  • -- Code Here
SELECT name AS nama, age AS umur FROM customers;
    • --- Code Here
    • -- Code Here
    • SELECT name AS nama, age AS umur FROM customers;
katonprayogivs.rishadharis

Basic Select 2 (BIE)

Code
Diff
  • -- Code Here
select name, age from customers
    • --- Code Here
    • -- Code Here
    • select name, age from customers
katonprayogivs.rishadharis

Basic Select (BIE)

Code
Diff
  • -- Code here
select * from customers
    • -- Code here
    • select * from customers