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

15 questions

Attacks Threats & Vulnerabilities (C1)

Quiz

•

9th - 12th Grade

15 questions

Unbound Report Quiz

Quiz

•

9th - 12th Grade

15 questions

Code.org Lesson 1-14

Quiz

•

9th - 12th Grade

19 questions

UNIT 1.2 MEMORY

Quiz

•

10th Grade

20 questions

Google SketchUp Tool

Quiz

•

KG - University

18 questions

PC Component Identification

Quiz

•

6th - 12th Grade

22 questions

Steve Jobs

Quiz

•

6th - 12th Grade

22 questions

1.2.4 Data Storage - OCR

Quiz

•

9th - 10th Grade

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

11 questions

How well do you know your Christmas Characters?

Lesson

•

3rd Grade

14 questions

Christmas Trivia

Quiz

•

5th Grade

20 questions

How the Grinch Stole Christmas

Quiz

•

5th Grade

Discover more resources for Computers

28 questions

logos

Lesson

•

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;