The table “records” below, which stores information about the employees at a small company. Identify the output from the following SQL: SELECT name FROM records WHERE supervisor = "Oliver Warbucks";

Ben Bitdiddle Olivia Warbucks Eben Scrooge

Ben Bitdiddle Eben Scrooge Olivia Warbucks

Olivia Warbucks Ben Bitdiddle Eben Scrooge

Olivia Warbucks Eben Scrooge Ben Bitdiddle

The table “records” below, which stores information about the employees at a small company. Identify the output from the following SQL: SELECT name FROM records WHERE supervisor = "Oliver Warbucks" ORDER BY name DESC;

Olivia Warbucks Eben Scrooge Ben Bitdiddle

Ben Bitdiddle Olivia Warbucks Eben Scrooge

Ben Bitdiddle Eben Scrooge Olivia Warbucks

Olivia Warbucks Ben Bitdiddle Eben Scrooge

CHAPTER9 Quiz

Authored by jasmine chen

Computers

10th Grade

Used 6+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

18 questions

Show all answers

OPEN ENDED QUESTION

3 mins • 1 pt

If input could be:
SELECT HospitalNumber, FirstName, FamilyName
FROM PATIENT
WHERE Consultant = 'Mr Smith';
What are the following output:

Evaluate responses using AI:

OFF

Answer explanation

OPEN ENDED QUESTION

3 mins • 1 pt

If input could be:
SELECT HospitalNumber, FirstName, FamilyName
FROM PATIENT
WHERE Consultant = 'Mr Smith'
ORDER BY FamilyName;
What are the following output could be:

Evaluate responses using AI:

OFF

Answer explanation

OPEN ENDED QUESTION

3 mins • 1 pt

Using the single table database PATIENT you have created:
Write an SQL query to list all Mr Jones’ patients.

Evaluate responses using AI:

OFF

Answer explanation

SELECT FirstName, FamilyName
FROM PATIENT
WHERE Consultant = 'Mr Jones';

OPEN ENDED QUESTION

3 mins • 1 pt

Using the single table database PATIENT you have created. Write an SQL query to list all the patients not in ward 6.

Evaluate responses using AI:

OFF

Answer explanation

SELECT FirstName, FamilyName
FROM PATIENT
WHERE WardNumber <> 6;

OPEN ENDED QUESTION

3 mins • 1 pt

Using the single table database PATIENT you have created.
Write an SQL query to list all the patients who arrived on 12/11/2022.

Evaluate responses using AI:

OFF

Answer explanation

SELECT FirstName, FamilyName
FROM PATIENT
WHERE DateOfAdmisson = '12/11/2022’;

OPEN ENDED QUESTION

3 mins • 1 pt

Using the single table database PATIENT you have created.
Write an SQL query to list all the patients who arrived between 12/10/2022 AND 30/10/2022.

Evaluate responses using AI:

OFF

Answer explanation

SELECT FirstName, FamilyName, DateOfAdmission
FROM PATIENT
WHERE DateOfAdmission >= '12/10/2022' AND DateOfAdmission <= '30/10/2022’ ;

OPEN ENDED QUESTION

3 mins • 1 pt

Using the single table database PATIENT you have created.
Write down the output from this SQL query.
SELECT FirstName, FamilyName, BedNumber
FROM PATIENT
WHEREWardNumber= 7;

Evaluate responses using AI:

OFF

Answer explanation

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

20 questions

SOAL ASTS INFORMATIKA

Quiz

•

10th Grade

20 questions

BP TIK 2

Quiz

•

10th Grade

15 questions

KD 3.1_Aplikasi Pengolah Angka / Spreadsheet

Quiz

•

10th Grade

18 questions

Algorithms and flow charts

Quiz

•

10th Grade

18 questions

Rolurile_SGBD

Quiz

•

1st Grade - University

20 questions

Key Applications 1

Quiz

•

9th - 12th Grade

15 questions

Records and Files

Quiz

•

8th - 11th Grade

22 questions

Programming Review

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

57 questions

[AP CSP] Unit 5 Review: Internet & Cybersecurity

Quiz

•

9th - 12th Grade

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

CHAPTER9 Quiz

If input could be:
SELECT HospitalNumber, FirstName, FamilyName
FROM PATIENT
WHERE Consultant = 'Mr Smith';
What are the following output:

If input could be:
SELECT HospitalNumber, FirstName, FamilyName
FROM PATIENT
WHERE Consultant = 'Mr Smith'
ORDER BY FamilyName;
What are the following output could be:

Using the single table database PATIENT you have created:
Write an SQL query to list all Mr Jones’ patients.

SELECT FirstName, FamilyName
FROM PATIENT
WHERE Consultant = 'Mr Jones';

Using the single table database PATIENT you have created. Write an SQL query to list all the patients not in ward 6.

SELECT FirstName, FamilyName
FROM PATIENT
WHERE WardNumber <> 6;

Using the single table database PATIENT you have created.
Write an SQL query to list all the patients who arrived on 12/11/2022.

SELECT FirstName, FamilyName
FROM PATIENT
WHERE DateOfAdmisson = '12/11/2022’;

Using the single table database PATIENT you have created.
Write an SQL query to list all the patients who arrived between 12/10/2022 AND 30/10/2022.

SELECT FirstName, FamilyName, DateOfAdmission
FROM PATIENT
WHERE DateOfAdmission >= '12/10/2022' AND DateOfAdmission <= '30/10/2022’ ;

Using the single table database PATIENT you have created.
Write down the output from this SQL query.
SELECT FirstName, FamilyName, BedNumber
FROM PATIENT
WHEREWardNumber= 7;

Using the single table database PATIENT you have created.
Write an SQL query to count the number of patients in ward 7.

SELECT Count (WardNumber)
FROM PATIENT
WHEREWardNumber= 7;

Using the single table database PATIENT you have created.
Write an SQL query to count the number of patients not in ward 7.

SELECT Count (WardNumber)
FROM PATIENT
WHEREWardNumber<> 7;

Using the single table database PATIENT you have created.
Write down the output from this SQL query.
SELECT HospitalNumber, FirstName, FamilyName, Consultant
FROM PATIENT
ORDER BY Consultant, FamilyName;

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

CHAPTER9 Quiz

If input could be:SELECT HospitalNumber, FirstName, FamilyNameFROM PATIENTWHERE Consultant = 'Mr Smith';What are the following output:

If input could be:SELECT HospitalNumber, FirstName, FamilyNameFROM PATIENTWHERE Consultant = 'Mr Smith'ORDER BY FamilyName;What are the following output could be:

Using the single table database PATIENT you have created:Write an SQL query to list all Mr Jones’ patients.

SELECT FirstName, FamilyNameFROM PATIENTWHERE Consultant = 'Mr Jones';

Using the single table database PATIENT you have created. Write an SQL query to list all the patients not in ward 6.

SELECT FirstName, FamilyNameFROM PATIENTWHERE WardNumber <> 6;

Using the single table database PATIENT you have created.Write an SQL query to list all the patients who arrived on 12/11/2022.

SELECT FirstName, FamilyNameFROM PATIENTWHERE DateOfAdmisson = '12/11/2022’;

Using the single table database PATIENT you have created.Write an SQL query to list all the patients who arrived between 12/10/2022 AND 30/10/2022.

SELECT FirstName, FamilyName, DateOfAdmission FROM PATIENTWHERE DateOfAdmission >= '12/10/2022' AND DateOfAdmission <= '30/10/2022’ ;

Using the single table database PATIENT you have created.Write down the output from this SQL query.SELECT FirstName, FamilyName, BedNumberFROM PATIENTWHEREWardNumber= 7;

Using the single table database PATIENT you have created.Write an SQL query to count the number of patients in ward 7.

SELECT Count (WardNumber) FROM PATIENTWHEREWardNumber= 7;

Using the single table database PATIENT you have created.Write an SQL query to count the number of patients not in ward 7.

SELECT Count (WardNumber) FROM PATIENTWHEREWardNumber<> 7;

Using the single table database PATIENT you have created.Write down the output from this SQL query.SELECT HospitalNumber, FirstName, FamilyName, ConsultantFROM PATIENTORDER BY Consultant, FamilyName;

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

If input could be:
SELECT HospitalNumber, FirstName, FamilyName
FROM PATIENT
WHERE Consultant = 'Mr Smith';
What are the following output:

If input could be:
SELECT HospitalNumber, FirstName, FamilyName
FROM PATIENT
WHERE Consultant = 'Mr Smith'
ORDER BY FamilyName;
What are the following output could be:

Using the single table database PATIENT you have created:
Write an SQL query to list all Mr Jones’ patients.

SELECT FirstName, FamilyName
FROM PATIENT
WHERE Consultant = 'Mr Jones';

SELECT FirstName, FamilyName
FROM PATIENT
WHERE WardNumber <> 6;

Using the single table database PATIENT you have created.
Write an SQL query to list all the patients who arrived on 12/11/2022.

SELECT FirstName, FamilyName
FROM PATIENT
WHERE DateOfAdmisson = '12/11/2022’;

Using the single table database PATIENT you have created.
Write an SQL query to list all the patients who arrived between 12/10/2022 AND 30/10/2022.

SELECT FirstName, FamilyName, DateOfAdmission
FROM PATIENT
WHERE DateOfAdmission >= '12/10/2022' AND DateOfAdmission <= '30/10/2022’ ;

Using the single table database PATIENT you have created.
Write down the output from this SQL query.
SELECT FirstName, FamilyName, BedNumber
FROM PATIENT
WHEREWardNumber= 7;

Using the single table database PATIENT you have created.
Write an SQL query to count the number of patients in ward 7.

SELECT Count (WardNumber)
FROM PATIENT
WHEREWardNumber= 7;

Using the single table database PATIENT you have created.
Write an SQL query to count the number of patients not in ward 7.

SELECT Count (WardNumber)
FROM PATIENT
WHEREWardNumber<> 7;

Using the single table database PATIENT you have created.
Write down the output from this SQL query.
SELECT HospitalNumber, FirstName, FamilyName, Consultant
FROM PATIENT
ORDER BY Consultant, FamilyName;