Menu
Coddy logo textTech
ÖĞRENMEYE BAŞLA
flag Tr iconTürkçedown icon

Recap - RANK & DENSE_RANK

Coddy'nin SQL Journey'sinin Temeller bölümünün bir parçası — ders 66 / 72.

challenge icon

Görev

Orta

Mevcut tablolar ve sütunlar:

  • <strong>medals</strong>: <strong>region</strong>, <strong>medal_color</strong>, <strong>medal_count</strong>

Bölgeler yarışmalarda madalya alır. Şu bilgileri gösteren bir rapor oluşturun:

  1. Her bölge için hesaplayın:
    • total_medals: Sahip oldukları tüm madalyaların toplamı
    • rank_by_medals: total_medals'e göre artan sırada yoğun bir sıralama oluşturun (daha az madalyaya sahip bölgeler daha iyi/düşük sıralar alır)
  2. Sonuçları şu şekilde sıralayın:
    • rank_by_medals (artan)
    • region (alfabetik olarak)

döndürün:

  • region
  • total_medals
  • rank_by_medals

Kendin dene

Temeller bölümündeki tüm dersler

1Introduction

IntroductionWhat is a databaseDatabase conceptsUnique values

4More Keywords

The IN keywordThe BETWEEN keywordThe LIKE keywordThe AS keywordRecap - Cellphone Models

7Dates

Handling Dates Part 1Handling Dates Part 2Handling Dates Part 3

10Imaginary Products

Adjust WattCalculate Product QualityProje dersiExpand To Other ProductsProje dersiCombine All ProductsProje dersiThe Overall AverageProje dersi

13Summary

Recap - CreaturesRecap - BooksRecap - Junk

2Conditions

Conditions BasicsThe AND keywordThe OR keywordThe NOT keywordMultiple Conditions CombinedParenthesisBooleans

5Arithmetic Operations

Mathematical OperatorsMathematical ColumnsThe Modulo OperationThe ROUND() Function

8Statistics

Built-In Aggregate Part 1Built-In Aggregate Part 2Grouping Part 1Grouping Part 2Subqueries Part 1Subqueries Part 2Recap - Total Gain ShopRecap - Scooter ShopRecap - Coffee Shop

11Window Functions part 1

ROW_NUMBER functionORDER BY criterionPARTITION BY criterionPARTITION & ORDERLEAD & LAG FunctionsRecap - LEAD & LAGRecap - PicturesRecap - Boxes

3Specific Return Format

Null valuesSort Results Part 1Sort Results Part 2Recap - Cyber Security FirmLimit number of recordsRecap - Vehicle Factory

6Intro Challenges

Recap - Parliamentary ElectionRecap - Police Criminal ArrestRecap - Bar Beverage ContainerRecap - Engineer new columns

9Multiple tables

Basic Join Part 1Basic Join Part 2Recap - JoinSelf joinRecap - Self JoinUnionSimplify queries, WITH keywordRecap - With QueriesRecap - Real Estate Contractor

12Window Functions part 2

RANK & DENSE_RANK FunctionsRecap - RANK & DENSE_RANKNTILE FunctionAggregation FunctionsROWS & RANGE Criterion