Yükleniyor...
Kod katası ile dil ustalığı ve yaratıcı problem çözme alışkanlıkları.
Platforma Göre:
Dile Göre:
Zorluğa Göre:
Soru Ara:
CodeWars - Adults only (SQL for Beginners #1) From the users table (name, age), return all users who are 18 or older.
CodeWars - Best-Selling Books (SQL for Beginners #5) From the books table (name, author, copies_sold), return the top 5 best-selling books ordered by copies sold (highest to lowest).
CodeWars - Easy SQL: Bit Length Given a demographics table (id, name, birthday, race), return the same table where all text fields (name & race) are replaced with the bit length of the string.
CodeWars - Collect Tuition (SQL for Beginners #4) From the students table (name, age, semester, mentor, tuition_received), return all students who have NOT yet paid their tuition.
CodeWars - Countries Capitals for Trivia Night (SQL for Beginners #6) From the countries table (country, capital, continent), return the capitals of African countries whose name starts with 'E', ordered alphabetically. Return at most 3 results. Note: continent may be stored as 'Africa' or 'Afrika'.
CodeWars - On the Canadian Border (SQL for Beginners #2) From the travelers table (name, country), return travelers who need a visa check — i.e. exclude citizens of USA, Canada, and Mexico.
CodeWars - SQL with Pokemon: Damage Multipliers You are battling Erika at the Celadon Gym (Grass-type). Using the pokemon (id, pokemon_name, element_id, str) and multipliers (id, element, multiplier) tables, return pokemon whose modifiedStrength (multiplier * str) >= 40, ordered from strongest to weakest. Output: pokemon_name, modifiedStrength, element i choose you! --
CodeWars - Register for the Party (SQL for Beginners #3) Insert yourself into the participants table (name, age, attending). Only attendees aged 21+ are allowed since alcohol is served.
CodeWars - SQL Basics: Repeat and Reverse Using the monsters table (id, name, legs, arms, characteristics), return name repeated three times and characteristics reversed. Output: name, characteristics
CodeWars - SQL Basics: Simple IN Using departments (id, name) and sales (id, department_id, name, price, card_name, card_number, transaction_date), return departments that have had at least one sale with a price over $98. Output: id, name
CodeWars - Third Angle of a Triangle Given a table 'otherangle' with columns 'a' and 'b' (two interior angles), return a, b and the third angle as 'res'. Sum of angles in a triangle = 180 degrees.
CodeWars - Top 10 customers by total payments Using the DVD Rental database, return the top 10 customers ordered by total amount spent (highest to lowest). Output columns: customer_id [int] email [varchar] payments_count [int] total_amount [float]