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

Authored by Turdali Jumayev

Computers

University

Used 14+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

20 questions

Show all answers

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.

FILL IN THE BLANK QUESTION

1 min • 1 pt

SELECT SUM(5.0+4);

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.

FILL IN THE BLANK QUESTION

1 min • 1 pt

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

FILL IN THE BLANK QUESTION

1 min • 1 pt

SELECT ROUND(SUM(5.0+4));

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.

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.

Access all questions and much more by creating a free account

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

18 questions

1-mavzu. Mobil ilovalar yaratish va ularning xavfsizligini ta’mi

Quiz

•

University

15 questions

Hurliman

Quiz

•

University

15 questions

Computer Software Basics: Multiple Choice Questions

Quiz

•

7th Grade - University

20 questions

MB-3

Quiz

•

1st Grade - University

17 questions

5-mavzu

Quiz

•

University

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

Valentines Day Trivia

Quiz

•

3rd Grade - University

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

5 questions

What is Presidents' Day?

Interactive video

•

10th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

20 questions

Mardi Gras History

Quiz

•

6th Grade - University

10 questions

The Roaring 20's Crash Course US History

Interactive video

•

11th Grade - University

17 questions

Review9_TEACHER

Quiz

•

University

MB-6

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);

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers