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
Data Science
7
Databases
43
Filtering
2
Fundamentals
43
Restricted
1
SQL
43
FEATURED TAGS
Cryptography
Data Science
Debugging
Games
Tutorials
43 Kata Found
6 kyu
Conditional Count
7,652
pmatseykanets
2 Issues Reported
SQL
Fundamentals
Databases
5 kyu
Relational division: Find all movies two actors cast in together
7,841
pmatseykanets
1 Issue Reported
Fundamentals
Databases
SQL
7 kyu
SQL with Pokemon: Damage Multipliers
8,091
sHale
1 Issue Reported
Fundamentals
SQL
Databases
Data Science
8 kyu
SQL Basics: Simple WHERE and ORDER BY
27,279
matt c
1 Issue Reported
SQL
Filtering
Databases
Fundamentals
Beta
Finding people with a speeding record
51
Crafto Hohenvels
Status:
Testing & feedback needed
Estimated Rank:
7 kyu
SQL
Databases
Fundamentals
7 kyu
First Normal Form
290
MacStan
SQL
Fundamentals
Databases
7 kyu
Factorial Fun: Using PostgreSQL to Generate a Table of Factorials
133
bornForThis
SQL
Databases
Fundamentals
5 kyu
The Most Dedicated Customers - 2000s Nostalgia
72
bornForThis
Databases
Fundamentals
SQL
5 kyu
Count Weekdays
1,532
pmatseykanets
1 Issue Reported
SQL
Fundamentals
Databases
6 kyu
Balance history
323
rsaryev
SQL
Databases
Fundamentals
6 kyu
Lost Popularity
195
bornForThis
Databases
Fundamentals
SQL
6 kyu
Analyzing Customer Rental Trends: Identifying Popular Movie Genres Across Multiple Months
130
bornForThis
Databases
SQL
Fundamentals
6 kyu
Unlocking the Popularity Secrets of Children's Films: Analyzing Rentals
168
bornForThis
Databases
Fundamentals
SQL
6 kyu
Rentals by Date Range
153
bornForThis
Databases
SQL
Fundamentals
6 kyu
Film Category Ratings Breakdown
239
bornForThis
SQL
Fundamentals
Databases
5 kyu
Top Five Movie Categories Rented At Each Store
461
bornForThis
1 Issue Reported
SQL
Databases
Fundamentals
6 kyu
Exclude 'Adults only' films watchers
341
bornForThis
1 Issue Reported
Databases
SQL
Fundamentals
Restricted
6 kyu
The Peculiar Taste of Store Owner
401
bornForThis
Databases
Fundamentals
SQL
7 kyu
Countries Capitals for Trivia Night (SQL for Beginners #6)
14,125
MaikelNabil
2 Issues Reported
Fundamentals
SQL
Databases
Data Science
7 kyu
SQL Basics: Simple JOIN with COUNT
20,541
matt c
SQL
Databases
Fundamentals
Beta
Candlestick Chart
22
rsaryev
3 Issues Reported
Status:
Testing & feedback needed
Estimated Rank:
4 kyu
SQL
Databases
Fundamentals
Beta
SQL Basics: Simple BETWEEN and ORDER BY
627
user354062
1 Issue Reported
Status:
Waiting for issues to be resolved
Estimated Rank:
8 kyu
Fundamentals
SQL
Databases
Filtering
7 kyu
SQL with LOTR: Elven Wildcards
9,806
sHale
Fundamentals
SQL
Databases
Data Science
7 kyu
SQL with Street Fighter: Total Wins
9,106
sHale
3 Issues Reported
Fundamentals
SQL
Databases
Data Science
7 kyu
SQL with Harry Potter: Sorting Hat Comparators
9,607
sHale
Fundamentals
SQL
Databases
Data Science
7 kyu
SQL with Sailor Moon: Thinking about JOINs...
8,475
sHale
1 Issue Reported
Fundamentals
SQL
Databases
7 kyu
GROCERY STORE: Real Price!
3,855
baaart
2 Issues Reported
SQL
Databases
Fundamentals
7 kyu
GROCERY STORE: Support Local Products
8,720
baaart
SQL
Databases
Fundamentals
7 kyu
GROCERY STORE: Logistic Optimisation
6,257
baaart
2 Issues Reported
SQL
Databases
Fundamentals
7 kyu
GROCERY STORE: Inventory
10,891
baaart
1 Issue Reported
SQL
Databases
Fundamentals
Loading...
Confirm
Collect:
undefined
Loading collection data...