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
234
Date Time
5
Filtering
2
Fundamentals
44
Mathematics
1
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
234 Kata Found
7 kyu
SQL: Party Votes in N-Prefixed States
79
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
690
bornForThis
SQL
Databases
Restricted
6 kyu
The Great Data Entry Blame Game
177
bornForThis
SQL
Databases
7 kyu
SQL with Pokemon: Damage Multipliers
8,038
sHale
1 Issue Reported
Fundamentals
SQL
Databases
Data Science
6 kyu
Find Inventory Changes Between Two Dates
97
bornForThis
1 Issue Reported
SQL
Databases
5 kyu
Simple data migration: assortment statuses
50
Twilight_Sun
SQL
Databases
6 kyu
Tracking Active Bookings Over Time
97
bornForThis
SQL
Databases
6 kyu
Building a User Leaderboard with Engagement Metrics
110
bornForThis
SQL
Databases
7 kyu
Identifying Mutual Likes in a Dating App
238
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
292
bornForThis
SQL
Databases
5 kyu
URL shortener
866
zLuki
Databases
Algorithms
Data Structures
6 kyu
Runner Results with Position-Based Competitor Info
192
bornForThis
SQL
Databases
6 kyu
Daily Hospital Admissions and Discharges Report
282
bornForThis
SQL
Databases
7 kyu
Categorize and Count Job Applications Based on Status
385
bornForThis
SQL
Databases
5 kyu
Analysis of Consecutive Stock Price Increases
84
bornForThis
SQL
Databases
6 kyu
Examining Traffic Data to Track Criminal Conduits
108
bornForThis
SQL
Databases
Date Time
7 kyu
Counting Interview Failures Without Using COUNT()
325
bornForThis
SQL
Databases
Restricted
6 kyu
Identifying Peak Hours for Angry Customer Calls
154
bornForThis
1 Issue Reported
SQL
Databases
6 kyu
Employee Weekend Work: Counting Unique Weekends and Total Days Worked
182
bornForThis
SQL
Databases
Date Time
6 kyu
Refactoring SQL Queries: part 2 (Pagination Disaster)
126
bornForThis
SQL
Databases
Refactoring
7 kyu
Uncover the Code: ABC Kata Solutions' Longest-Tenured Employees
370
bornForThis
SQL
Databases
7 kyu
Ten Years of Talent: Analyzing Employee Flux at ABC Kata Solutions
243
bornForThis
SQL
Databases
7 kyu
ABC Kata Solutions' Failures That Paved the Road to Success
225
bornForThis
SQL
Databases
8 kyu
SQL Basics: Simple WHERE and ORDER BY
27,135
matt c
1 Issue Reported
SQL
Filtering
Databases
Fundamentals
7 kyu
Uncovering ABC Kata Solutions' Most Extravagant Departmental Expenses
186
bornForThis
SQL
Databases
6 kyu
Monthly Landlord Revenue Report Generation
207
bornForThis
SQL
Databases
Loading...
Confirm
Collect:
undefined
Loading collection data...