Quizizz Week 12

Quizizz Week 12

University

8 Qs

quiz-placeholder

Similar activities

ECM3434 Business Analysis 1 - Data Modelling

ECM3434 Business Analysis 1 - Data Modelling

University

10 Qs

ECM3434 Business Analysis 1 - Business process modelling

ECM3434 Business Analysis 1 - Business process modelling

University

10 Qs

MULTIMEDIA ANIMATION

MULTIMEDIA ANIMATION

University

13 Qs

Quiz CodeIgniter 4

Quiz CodeIgniter 4

University

10 Qs

Computer Basics Quiz

Computer Basics Quiz

8th Grade - University

10 Qs

Structured Cabling

Structured Cabling

University

10 Qs

استعني علي الشقا بالله

استعني علي الشقا بالله

University

10 Qs

PYTHON_CHAPTER 6

PYTHON_CHAPTER 6

University

10 Qs

Quizizz Week 12

Quizizz Week 12

Assessment

Quiz

Computers

University

Practice Problem

Hard

Created by

Jason Holloway

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

8 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Media Image

Which SELECT query produced this output?

SELECT *

FROM tutorials.ARTIST

WHERE Nationality = 'United States';

SELECT *

FROM tutorials.ARTIST

WHERE DateOfBirth < 1920;

SELECT ArtistID, FirstName, Nationality, DateOfBirth, DateDeceased

FROM tutorials.ARTIST;

SELECT *

FROM tutorials.ARTIST

WHERE ArtistID > 11;

2.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Media Image

Which SELECT query produced this output?

SELECT W.WorkID, W.ArtistID

FROM (

SELECT WorkID, ArtistID

FROM tutorials.WORK

) W;

SELECT *

FROM tutorials.WORK

WHERE WorkID > 537;

SELECT WorkID, ArtistID

FROM tutorials.WORK W JOIN tutorials.ARTIST A

ON W.ArtsitID = A.ArtistID

WHERE ArtistID = 17;

SELECT WorkID, ArtistID

FROM tutorials.WORK

WHERE ArtistID = 17;

3.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Media Image

What SELECT query produced this output?

SELECT DateAcquired, FirstName, LastName

FROM tutorials.TRANS T JOIN tutorials.CUSTOMER C

ON T.CustomerID = C.CustomerID

WHERE FirstName LIKE '%y';

SELECT DateAcquired, FirstName, LastName

FROM tutorials.TRANS T JOIN tutorials.CUSTOMER C

ON T.CustomerID = C.CustomerID

WHERE DateAcquired < '2006-1-1';

SELECT *

FROM tutorials.TRANS T JOIN tutorials.CUSTOMER C

ON T.FirstName = C.FirstName

WHERE DateAcquired < '2006-1-1';

SELECT DateAcquired, FirstName, LastName

FROM tutorials.TRANS T JOIN tutorials.ARTIST A

ON T.ArtistID = A.ArtistID;

4.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Media Image

What SELECT query produced this output?

SELECT W.ArtistID, COUNT(*) AS TransCount

FROM tutorials.TRANS T JOIN tutorials.WORK W

ON T.WorkID = W.WorkID

GROUP BY W.ArtistID

ORDER BY TransCount DESC;

SELECT A.ArtistID, COUNT(*) AS TransCount

FROM tutorials.TRANS T

JOIN tutorials.ARTIST A

ON T.ArtistID = A.ArtistID

GROUP BY A.ArtistID

ORDER BY TransCount DESC;

SELECT W.ArtistID, COUNT(*) AS TransCount

FROM tutorials.TRANS T JOIN tutorials.WORK W

ON T.WorkID = W.WorkID

GROUP BY W.ArtistID;

SELECT A.ArtistID, COUNT(*) AS TransCount

FROM tutorials.TRANS T JOIN tutorials.WORK W

ON T.WorkID = W.WorkID

JOIN tutorials.ARTIST A

ON W.ArtistID = A.ArtistID

GROUP BY A.ArtistID;

5.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

How can we find the ArtistID with the most works?

SELECT ArtistID, COUNT(Title) AS WorkCount

FROM tutorials.WORK

GROUP BY ArtistID

HAVING WorkCount = MAX(ArtistID)

ORDER BY WorkCount DESC;

SELECT ArtistID, MAX(COUNT(Title))

FROM tutorials.WORK

GROUP BY ArtistID;

SELECT ArtistID, SUM(WorkID) AS WorkCount

FROM tutorials.WORK

GROUP BY ArtistID

ORDER BY WorkCount DESC

LIMIT 1;

SELECT ArtistID, COUNT(Title) AS WorkCount

FROM tutorials.WORK

GROUP BY ArtistID

ORDER BY WorkCount DESC

FETCH FIRST 1 ROWS ONLY;

6.

FILL IN THE BLANK QUESTION

1 min • 1 pt

How can we add the AskingPrice for all transactions?

DO NOT RENAME THE COLUMN AND

WRITE YOUR ANSWER AS ONE LINE.

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is the correct order of INSERT statements?

INSERT INTO WORK

VALUES(...);

INSERT INTO CUSTOMER

VALUES(...);

INSERT INTO ARTIST

VALUES(...);

INSERT INTO TRANS

VALUES(...);

INSERT INTO CUSTOMER

VALUES(...);

INSERT INTO ARTIST

VALUES(...);

INSERT INTO WORK

VALUES(...);

INSERT INTO TRANS

VALUES(...);

INSERT INTO ARTIST

VALUES(...);

INSERT INTO TRANS

VALUES(...);

INSERT INTO CUSTOMER

VALUES(...);

INSERT INTO WORK

VALUES(...);

INSERT INTO TRANS

VALUES(...);

INSERT INTO ARTIST

VALUES(...);

INSERT INTO WORK

VALUES(...);

INSERT INTO CUSTOMER

VALUES(...);

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?