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
2
Cryptography
1
Data Science
8
Databases
230
Date Time
5
Filtering
2
Fundamentals
43
Parsing
1
Performance
3
Puzzles
4
Refactoring
4
Restricted
10
SQL
230
Security
1
Sets
1
Statistics
1
Strings
1
FEATURED TAGS
Cryptography
Data Science
Debugging
Games
Tutorials
230 Kata Found
7 kyu
SQL: Party Votes in N-Prefixed States
44
x4g4p3x
SQL
Databases
Strings
Beta
Count Voters with High School Diplomas per Party
13
x4g4p3x
2 Issues Reported
Status:
Waiting for issues to be resolved
Estimated Rank:
6 kyu
SQL
Databases
Beta
Count Voters per Party (Alphabetically)
16
x4g4p3x
Status:
Testing & feedback needed
Estimated Rank:
7 kyu
SQL
Databases
Beta
Average Male/Female Voter Age by Party
11
x4g4p3x
1 Issue Reported
Status:
Waiting for issues to be resolved
Estimated Rank:
6 kyu
SQL
Databases
6 kyu
Youngest Team Members
672
bornForThis
SQL
Databases
Restricted
6 kyu
The Great Data Entry Blame Game
170
bornForThis
SQL
Databases
7 kyu
SQL with Pokemon: Damage Multipliers
8,015
sHale
1 Issue Reported
Fundamentals
SQL
Databases
Data Science
6 kyu
Find Inventory Changes Between Two Dates
95
bornForThis
1 Issue Reported
SQL
Databases
5 kyu
Simple data migration: assortment statuses
49
Twilight_Sun
SQL
Databases
6 kyu
Tracking Active Bookings Over Time
93
bornForThis
SQL
Databases
6 kyu
Building a User Leaderboard with Engagement Metrics
104
bornForThis
SQL
Databases
7 kyu
Identifying Mutual Likes in a Dating App
233
bornForThis
SQL
Databases
6 kyu
Finding Products Matching All Selected Tags: Parameterized Version
60
bornForThis
SQL
Databases
7 kyu
Finding Products Matching All Selected Tags
285
bornForThis
SQL
Databases
6 kyu
Runner Results with Position-Based Competitor Info
190
bornForThis
SQL
Databases
6 kyu
Daily Hospital Admissions and Discharges Report
279
bornForThis
SQL
Databases
7 kyu
Categorize and Count Job Applications Based on Status
381
bornForThis
SQL
Databases
5 kyu
Analysis of Consecutive Stock Price Increases
82
bornForThis
SQL
Databases
6 kyu
Examining Traffic Data to Track Criminal Conduits
107
bornForThis
SQL
Databases
Date Time
7 kyu
Counting Interview Failures Without Using COUNT()
322
bornForThis
SQL
Databases
Restricted
6 kyu
Identifying Peak Hours for Angry Customer Calls
153
bornForThis
1 Issue Reported
SQL
Databases
6 kyu
Employee Weekend Work: Counting Unique Weekends and Total Days Worked
180
bornForThis
SQL
Databases
Date Time
6 kyu
Refactoring SQL Queries: part 2 (Pagination Disaster)
124
bornForThis
SQL
Databases
Refactoring
7 kyu
Uncover the Code: ABC Kata Solutions' Longest-Tenured Employees
366
bornForThis
SQL
Databases
7 kyu
Ten Years of Talent: Analyzing Employee Flux at ABC Kata Solutions
242
bornForThis
SQL
Databases
7 kyu
ABC Kata Solutions' Failures That Paved the Road to Success
223
bornForThis
SQL
Databases
8 kyu
SQL Basics: Simple WHERE and ORDER BY
27,085
matt c
1 Issue Reported
SQL
Filtering
Databases
Fundamentals
7 kyu
Uncovering ABC Kata Solutions' Most Extravagant Departmental Expenses
185
bornForThis
SQL
Databases
6 kyu
Monthly Landlord Revenue Report Generation
206
bornForThis
SQL
Databases
5 kyu
Check passwords by hashes
33
Twilight_Sun
SQL
Databases
Performance
Cryptography
Loading...
Confirm
Collect:
undefined
Loading collection data...