BaşlayınÜcretsiz Başlayın

Number of customers

You have to give an overview of the number of customers for a presentation.

Bu egzersiz

Data-Driven Decision Making in SQL

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

  • Generate a table with the total number of customers, the number of customers for each country, and the number of female and male customers for each country.
  • Order the result by country and gender.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

-- Count the total number of customers, the number of customers for each country, and the number of female and male customers for each country
SELECT country,
       gender,
	   COUNT(*)
FROM customers
___ (___, ___)
___ ___, ___; -- Order the result by country and gender
Kodu Düzenle ve Çalıştır