Kata Library
Sign Up
Time to claim your honor
Training
Practice
Complete challenging
Kata
to earn honor and ranks. Re-train to hone technique
Freestyle Sparring
Take turns remixing and refactoring others code through
Kumite
Community
Leaderboards
Achieve honor and move up the global leaderboards
Chat
Join our
Discord
server and chat with your fellow code warriors
Discussions
View our
Github Discussions
board to discuss general Codewars topics
About
Docs
Learn about all of the different aspects of Codewars
Blog
Read the latest news from Codewars and the community
Log In
Sign Up
Library
Collections
Newest
Oldest
Popularity
Positive Feedback
Most Completed
Least Completed
Hardest
Easiest
Name
Relevance
Low Satisfaction
All
My Languages
Agda (Beta)
BF (Beta)
C
CFML (Beta)
Clojure
COBOL (Beta)
CoffeeScript
CommonLisp (Beta)
Coq
C++
Crystal
C#
D (Beta)
Dart
Elixir
Elm (Beta)
Erlang (Beta)
Factor (Beta)
Forth (Beta)
Fortran (Beta)
F#
Go
Groovy
Haskell
Haxe (Beta)
Idris (Beta)
Java
JavaScript
Julia (Beta)
Kotlin
λ Calculus (Beta)
Lean
Lua
NASM
Nim (Beta)
Objective-C (Beta)
OCaml (Beta)
Pascal (Beta)
Perl (Beta)
PHP
PowerShell (Beta)
Prolog (Beta)
PureScript (Beta)
Python
R (Beta)
Racket
Raku (Beta)
Reason (Beta)
RISC-V (Beta)
Ruby
Rust
Scala
Shell
Solidity (Beta)
SQL
Swift
TypeScript
VB (Beta)
Approved & Beta
Approved
Beta
All
Kata I have not trained on
Kata I have not completed
Kata I have completed
8 kyu
easiest
7 kyu
6 kyu
5 kyu
4 kyu
3 kyu
2 kyu
1 kyu
hardest
Algorithms
3
Cryptography
1
Data Science
8
Data Structures
1
Databases
227
Date Time
5
Filtering
1
Fundamentals
40
Mathematics
1
Parsing
1
Performance
3
Puzzles
4
Refactoring
4
Restricted
10
SQL
224
Security
1
Sets
1
Statistics
1
Strings
1
FEATURED TAGS
Cryptography
Data Science
Debugging
Games
Tutorials
227 Kata Found
6 kyu
One House, Many Claims: Detect Duplicate Address Applications
35
bornForThis
SQL
Databases
6 kyu
Conditional Count
7,643
pmatseykanets
2 Issues Reported
SQL
Fundamentals
Databases
5 kyu
Relational division: Find all movies two actors cast in together
7,839
pmatseykanets
1 Issue Reported
Fundamentals
Databases
SQL
7 kyu
SQL: Party Votes in N-Prefixed States
117
x4g4p3x
SQL
Databases
Strings
6 kyu
Youngest Team Members
728
bornForThis
SQL
Databases
Restricted
6 kyu
The Great Data Entry Blame Game
192
bornForThis
SQL
Databases
7 kyu
SQL with Pokemon: Damage Multipliers
8,089
sHale
1 Issue Reported
Fundamentals
SQL
Databases
Data Science
6 kyu
Find Inventory Changes Between Two Dates
104
bornForThis
1 Issue Reported
SQL
Databases
5 kyu
Simple data migration: assortment statuses
53
Twilight_Sun
SQL
Databases
6 kyu
Tracking Active Bookings Over Time
108
bornForThis
SQL
Databases
6 kyu
Building a User Leaderboard with Engagement Metrics
116
bornForThis
SQL
Databases
7 kyu
Identifying Mutual Likes in a Dating App
251
bornForThis
SQL
Databases
6 kyu
Finding Products Matching All Selected Tags: Parameterized Version
65
bornForThis
SQL
Databases
7 kyu
Finding Products Matching All Selected Tags
314
bornForThis
SQL
Databases
5 kyu
URL shortener
870
zLuki
Databases
Algorithms
Data Structures
6 kyu
Runner Results with Position-Based Competitor Info
197
bornForThis
SQL
Databases
6 kyu
Daily Hospital Admissions and Discharges Report
293
bornForThis
SQL
Databases
7 kyu
Categorize and Count Job Applications Based on Status
400
bornForThis
SQL
Databases
5 kyu
Analysis of Consecutive Stock Price Increases
85
bornForThis
SQL
Databases
6 kyu
Examining Traffic Data to Track Criminal Conduits
113
bornForThis
SQL
Databases
Date Time
7 kyu
Counting Interview Failures Without Using COUNT()
335
bornForThis
SQL
Databases
Restricted
6 kyu
Identifying Peak Hours for Angry Customer Calls
157
bornForThis
1 Issue Reported
SQL
Databases
6 kyu
Employee Weekend Work: Counting Unique Weekends and Total Days Worked
185
bornForThis
SQL
Databases
Date Time
6 kyu
Refactoring SQL Queries: part 2 (Pagination Disaster)
131
bornForThis
SQL
Databases
Refactoring
7 kyu
Uncover the Code: ABC Kata Solutions' Longest-Tenured Employees
379
bornForThis
SQL
Databases
7 kyu
Ten Years of Talent: Analyzing Employee Flux at ABC Kata Solutions
248
bornForThis
SQL
Databases
7 kyu
ABC Kata Solutions' Failures That Paved the Road to Success
227
bornForThis
SQL
Databases
8 kyu
SQL Basics: Simple WHERE and ORDER BY
27,269
matt c
1 Issue Reported
SQL
Filtering
Databases
Fundamentals
7 kyu
Uncovering ABC Kata Solutions' Most Extravagant Departmental Expenses
190
bornForThis
SQL
Databases
6 kyu
Monthly Landlord Revenue Report Generation
213
bornForThis
SQL
Databases
Loading...
Confirm
Collect:
undefined
Loading collection data...