SQL tilida COUNT(*) agregat funksiyasining vazifasi nimadan iborat?

So‘rov natijalari jadvalidagi satrlar sonini hisoblaydi.

Ustundagi bo'sh bo'lmagan qiymatlar sonini hisoblaydi.

SQL tilida COUNT(ustun) agregat funksiyasining vazifasi nimadan iborat?

Ustundagi bo'sh bo'lmagan qiymatlar sonini hisoblaydi.

So‘rov natijalari jadvalidagi satrlar sonini hisoblaydi.

BETWEEN operatori vazifasi - bu

diapazonga tegishliligini tekshirishdir

OFFSET buyrug’i – ... vazifasini bajaradi.

dastlabki bir nechtasi tashlab yuborib, keyingi bir nechtasini olish

qaytarilmaydigan qiymatlar hosil qilish

qaytariluvchi qiymatlar hosil qilish

dastlabki bir nechta qatordagi ma’lumotni olish

2020-yilda ishlab chiqarilgan avtomobillarning umumiy narxini hisoblang.

SELECT SUM(price) FROM car WHERE year = 2020;

SELECT SUM(price) FROM car WHERE year < 2020;

SELECT AVG(price) FROM car WHERE year = 2020;

Har bir mamlakatda nechta avtomobil borligini, lekin faqat 5 tadan ortiq avtomobilga ega mamlakatlarni ko‘rsating?

SELECT country, COUNT(*) FROM car GROUP BY country HAVING COUNT(*) > 5;

SELECT country, COUNT(*) FROM car;

SELECT COUNT(*) FROM car GROUP BY country;

SELECT country, COUNT(*) FROM car GROUP BY country HAVING COUNT(*) = 5;

2021-yilda ishlab chiqarilgan avtomobillar orasida eng qimmat narxni toping?

SELECT MAX(price) FROM car WHERE year = 2021;

SELECT MAX(price) FROM car WHERE year > 2021;

SELECT MIN(price) FROM car WHERE year < 2021;

SELECT MIN(price) FROM car WHERE year = 2021;

Eng qimmat va eng arzon avtomobillar narxlarini yonma-yon chiqaring?

SELECT MAX(price) AS eng_qimmat, MIN(price) AS eng_arzon FROM car;

SELECT MIN(price) AS eng_qimmat, MAX(price) AS eng_arzon FROM car;

SELECT MAX(price) AS eng_qimmat FROM car;

SELECT MIN(price) AS eng_arzon FROM car;

MB-6

Quiz

•

Computers

•

University

•

Practice Problem

•

Medium

Turdali Jumayev

Used 14+ times

FREE Resource

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL tilida SUM() agregat funksiyasining vazifasi nimadan iborat?

Ustundagi barcha qiymatlar summasini hisoblaydi.

Ustundagi barcha qiymatlar eng kichigini aniqlaydi.

Ustundagi barcha qiymatlar o‘rtasi qiymatini xisoblaydi.

Ustundagi barcha qiymatlar eng kattasini aniqlaydi.

2.

FILL IN THE BLANK QUESTION

1 min • 1 pt

SELECT SUM(5.0+4);

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL tilida AVG() agregat funksiyasining vazifasi nimadan iborat?

Ustundagi barcha qiymatlar summasini hisoblaydi.

Ustundagi barcha qiymatlar eng kichigini aniqlaydi.

Ustundagi barcha qiymatlar o‘rtacha qiymatini xisoblaydi.

Ustundagi barcha qiymatlar eng kattasini aniqlaydi.

4.

FILL IN THE BLANK QUESTION

1 min • 1 pt

SELECT ROUND(AVG(7+5), 2);

5.

FILL IN THE BLANK QUESTION

1 min • 1 pt

SELECT ROUND(SUM(5.0+4));

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL tilida MIN() agregat funksiyasining vazifasi nimadan iborat?

Ustundagi xamma qiymatlar summasini hisoblaydi.

Ustundagi barcha qiymatlar orasidan eng kichigini aniqlaydi.

Ustundagi xamma qiymatlar o‘rtacha qiymatini xisoblaydi.

Ustundagi xamma qiymatlar eng kattasini aniqlaydi.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL tilida MAX() agregat funksiyasining vazifasi nimadan iborat?

Ustundagi xamma qiymatlar summasini hisoblaydi.

Ustundagi barcha qiymatlar orasidan eng kattasini aniqlaydi.

Ustundagi xamma qiymatlar o‘rtacha qiymatini xisoblaydi.

Ustundagi xamma qiymatlar eng kichigini aniqlaydi.

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

15 questions

Soal TCP/IP, UDP

Quiz

•

University

20 questions

Kuis Proses

Quiz

•

University

Popular Resources on Wayground

10 questions

Honoring the Significance of Veterans Day

Interactive video

•

6th - 10th Grade

9 questions

FOREST Community of Caring

Lesson

•

1st - 5th Grade

10 questions

Exploring Veterans Day: Facts and Celebrations for Kids

Interactive video

•

6th - 10th Grade

19 questions

Veterans Day

Quiz

•

5th Grade

14 questions

General Technology Use Quiz

Quiz

•

8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

15 questions

Circuits, Light Energy, and Forces

Quiz

•

5th Grade

19 questions

Thanksgiving Trivia

Quiz

•

6th Grade

Discover more resources for Computers

20 questions

Definite and Indefinite Articles in Spanish (Avancemos)

Quiz

•

8th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

9 questions

Principles of the United States Constitution

Interactive video

•

University

18 questions

Realidades 2 2A reflexivos

Quiz

•

7th Grade - University

10 questions

Dichotomous Key

Quiz

•

KG - University

25 questions

Integer Operations

Quiz

•

KG - University

7 questions

What Is Narrative Writing?

Interactive video

•

4th Grade - University

20 questions

SER vs ESTAR

Quiz

•

7th Grade - University

MB-6

20 questions

SQL tilida SUM() agregat funksiyasining vazifasi nimadan iborat?

SELECT SUM(5.0+4);

SQL tilida AVG() agregat funksiyasining vazifasi nimadan iborat?

SELECT ROUND(AVG(7+5), 2);

SELECT ROUND(SUM(5.0+4));

SQL tilida MIN() agregat funksiyasining vazifasi nimadan iborat?

SQL tilida MAX() agregat funksiyasining vazifasi nimadan iborat?

SQL tilida COUNT(*) agregat funksiyasining vazifasi nimadan iborat?

SQL tilida COUNT(ustun) agregat funksiyasining vazifasi nimadan iborat?

Ushbu SQL so'rovning natijasi nima chiqadi? SELECT TRUNC(3.5 + 2.6);

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers