Quizizz Week 12

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;

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;

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;

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;

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;

How can we add the AskingPrice for all transactions?

DO NOT RENAME THE COLUMN AND

WRITE YOUR ANSWER AS ONE LINE.

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

What is the correct order of DELETE statements?

• DELETE FROM CUSTOMER...

  DELETE FROM ARTIST...

  DELETE FROM TRANS...

  DELETE FROM WORK...

• DELETE FROM ARTIST...

  DELETE FROM CUSTOMER...

  DELETE FROM WORK...

  DELETE FROM TRANS...

• DELETE FROM TRANS...

  DELETE FROM ARTIST...

  DELETE FROM WORK...

  DELETE FROM CUSTOMER...

• DELETE FROM TRANS...

  DELETE FROM WORK...

  DELETE FROM ARTIST...

  DELETE FROM CUSTOMER...