Search Header Logo

SQL - 04 - Count, AVG, SUM...

Authored by Mirko Martinović

Computers

10th Grade

Used 4+ times

SQL - 04 - Count, AVG, SUM...
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

7 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Funkcija koja vraća broj redaka koji odgovara određenom kriteriju je

COUNT

AVG

SUM

Like

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Funkcija koja vraća prosječnu vrijednost unutar stupca je

COUNT

AVG

SUM

Like

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Funkcija koja vraća ukupni zbroj vrijednosti unutar stupca je

COUNT

AVG

SUM

Like

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Koji operator se koristi u klauzuli WHERE za traženje određenog uzorka u stupcu.

WILDCARDS

LIKE

IN

BETWEEN

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Koji operator vam omogućuje da navedete više vrijednosti u klauzuli WHERE.

COUNT

BETWEEN

IN

SUM

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Koji operator odabire vrijednosti unutar zadanog raspona. Vrijednosti mogu biti brojevi, tekst ili datumi.

SUM

AVG

COUNT

BETWEEN

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Koji izraz se koristi za kombiniranje redaka iz dvije ili više tablica?

WILDCARDS

LIKE

JOIN

BETWEEN

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?