HAVING ve sıralama

Filtreleme ve sıralama ayrılmaz bir ikilidir ve sonuçları sıralayarak daha iyi yorumlanabilirlik sağlar.

Ortalama film bütçesi en yüksek olan ülkelerin hangileri olduğunu gösteren bir sorgu yazarak bu sihrin nasıl çalıştığını görelim.

Bu egzersiz, kursun bir parçasıdır

Orta Düzey SQL

Kursa Göz Atın

Egzersiz talimatları

country alanını ve ortalama bütçe olarak films içinden iki ondalık basamağa yuvarlanmış average_budget alanını seçin.
Sonuçları country değerine göre gruplandırın.
Sonuçları, ortalama bütçesi bir milyardan (1000000000) fazla olan ülkelere göre filtreleyin.
average_budget değişkenini azalan düzende sıralayın.

Uygulamalı etkileşimli egzersiz

Bu egzersizi bu örnek kodu tamamlayarak deneyin.

-- Select the country and average_budget from films
___
-- Group by country
___
-- Filter to countries with an average_budget of more than one billion
___
-- Order by descending order of the aggregated budget
___

Kodu Düzenle ve Çalıştır

Bu egzersiz, kursun bir parçasıdır

Orta Düzey SQL

InicianteNível de habilidade

4.9+

Kursa Ücretsiz Başla

In this first chapter, you’ll learn how to query a films database and select the data needed to answer questions about the movies and actors. You'll also understand how SQL code is executed and formatted.

Exercise 1: Querying a database Exercise 2: Learning to COUNT()Exercise 3: Practice with COUNT()Exercise 4: SELECT DISTINCT Exercise 5: Query execution Exercise 6: Order of execution Exercise 7: Debugging errors Exercise 8: SQL style Exercise 9: SQL best practices Exercise 10: Formatting Exercise 11: Non-standard fields

Learn about how you can filter numerical and textual data with SQL. Filtering is an important use for this language. You’ll learn how to use new keywords and operators to help you narrow down your query to get results that meet your desired criteria and gain a better understanding of NULL values and how to handle them.

Exercise 1: Filtering numbers Exercise 2: Filtering results Exercise 3: Using WHERE with numbers Exercise 4: Using WHERE with text Exercise 5: Multiple criteria Exercise 6: Using AND Exercise 7: Using OR Exercise 8: Using BETWEEN Exercise 9: Filtering text Exercise 10: LIKE and NOT LIKE Exercise 11: WHERE IN Exercise 12: Combining filtering and selecting Exercise 13: NULL values Exercise 14: What does NULL mean?Exercise 15: Practice with NULLs

SQL allows you to zoom in and out to better understand an entire dataset, its subsets, and its individual records. You'll learn to summarize data using aggregate functions and perform basic arithmetic calculations inside queries to gain insights into what makes a successful film.

Exercise 1: Summarizing data Exercise 2: Aggregate functions and data types Exercise 3: Practice with aggregate functions Exercise 4: Summarizing subsets Exercise 5: Combining aggregate functions with WHERE Exercise 6: Using ROUND()Exercise 7: ROUND() with a negative parameter Exercise 8: Aliasing and arithmetic Exercise 9: Using arithmetic Exercise 10: Aliasing with functions Exercise 11: Rounding results

This final chapter teaches you how to sort and group data. These skills will take your analyses to a new level by helping you uncover critical business insights and identify trends and performance. You'll get hands-on experience to determine which films performed the best and how movie durations and budgets changed over time.

Exercise 1: Sonuçları sıralama Exercise 2: Metin sıralama Exercise 3: Tek alanları sıralama Exercise 4: Birden fazla alanı sıralama Exercise 5: Veri gruplandırma Exercise 6: GROUP BY tekli alanlar Exercise 7: GROUP BY birden fazla alan Exercise 8: İş sorularını yanıtlama Exercise 9: Gruplandırılmış verileri filtreleme Exercise 10: HAVING ile filtreleme Exercise 11: HAVING ve sıralama

Geçerli egzersiz

Exercise 12: Şimdi hep birlikte Exercise 13: Tebrikler!