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
75
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
681
bornForThis
SQL
Databases
Restricted
6 kyu
The Great Data Entry Blame Game
174
bornForThis
SQL
Databases
7 kyu
SQL with Pokemon: Damage Multipliers
8,031
sHale
1 Issue Reported
Fundamentals
SQL
Databases
Data Science
6 kyu
Find Inventory Changes Between Two Dates
96
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
96
bornForThis
SQL
Databases
6 kyu
Building a User Leaderboard with Engagement Metrics
108
bornForThis
SQL
Databases
7 kyu
Identifying Mutual Likes in a Dating App
237
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
290
bornForThis
SQL
Databases
6 kyu
Runner Results with Position-Based Competitor Info
192
bornForThis
SQL
Databases
6 kyu
Daily Hospital Admissions and Discharges Report
281
bornForThis
SQL
Databases
7 kyu
Categorize and Count Job Applications Based on Status
384
bornForThis
SQL
Databases
5 kyu
Analysis of Consecutive Stock Price Increases
84
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()
324
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
182
bornForThis
SQL
Databases
Date Time
6 kyu
Refactoring SQL Queries: part 2 (Pagination Disaster)
125
bornForThis
SQL
Databases
Refactoring
7 kyu
Uncover the Code: ABC Kata Solutions' Longest-Tenured Employees
369
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,119
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
5 kyu
Check passwords by hashes
33
Twilight_Sun
SQL
Databases
Performance
Cryptography
Loading...
Confirm
Collect:
undefined
Loading collection data...