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
7
Cryptography
1
Data Science
13
Databases
230
Date Time
5
Filtering
2
Fundamentals
99
JSON
1
Mathematics
6
Metaprogramming
1
Parsing
1
Performance
4
Puzzles
5
Recursion
1
Refactoring
5
Regular Expressions
3
Restricted
11
SQL
295
Security
1
Sets
1
Statistics
2
Strings
9
FEATURED TAGS
Cryptography
Data Science
Debugging
Games
Tutorials
295 Kata Found
7 kyu
SQL: Party Votes in N-Prefixed States
85
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
695
bornForThis
SQL
Databases
Restricted
6 kyu
The Great Data Entry Blame Game
180
bornForThis
SQL
Databases
7 kyu
SQL with Pokemon: Damage Multipliers
8,048
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
51
Twilight_Sun
SQL
Databases
6 kyu
Tracking Active Bookings Over Time
99
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
241
bornForThis
SQL
Databases
6 kyu
Finding Products Matching All Selected Tags: Parameterized Version
61
bornForThis
SQL
Databases
7 kyu
Finding Products Matching All Selected Tags
294
bornForThis
SQL
Databases
6 kyu
Runner Results with Position-Based Competitor Info
192
bornForThis
SQL
Databases
7 kyu
Number of countries visited
699
atlas_codes
SQL
6 kyu
Daily Hospital Admissions and Discharges Report
284
bornForThis
SQL
Databases
7 kyu
Categorize and Count Job Applications Based on Status
389
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()
328
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
372
bornForThis
SQL
Databases
7 kyu
Ten Years of Talent: Analyzing Employee Flux at ABC Kata Solutions
244
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,154
matt c
1 Issue Reported
SQL
Filtering
Databases
Fundamentals
7 kyu
Uncovering ABC Kata Solutions' Most Extravagant Departmental Expenses
189
bornForThis
SQL
Databases
6 kyu
Monthly Landlord Revenue Report Generation
207
bornForThis
SQL
Databases
Loading...
Confirm
Collect:
undefined
Loading collection data...