Show the students’ first and last name who have gotten ‘A’ at least once by using sub query

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
  1. Show the students’ first and last name who have gotten ‘A’ at least once by using sub query.

 

DB Browser for SQLite - C:\Users\13309\OneDrive\Desktop\sqlite\LabAssignment3.sqlite
File Edit View Tools Help
@New Database
Open Database
Write Changes
Revert Changes
Open Project
Save Project
Attach Database
X Close Database
Database Structure Browse Data Edit Pragmas Execute SQL
Table: STUDENT
ba Filter in any column
Is Active
Filter
StudentID StudentLastName StudentFirstName
DOB
Filter
|Filter
Filter
Filter
1
100001 Johnson
Ariel
1999-07-10
N
100002 Green
Robin
2001-11-02
N
3
100003 Johnson
Charles
1995-01-12
N
4
100004 Pearson
Jeffery
1996-02-06
N
5
100005 Sears
Miguel
1998-10-31
N
6
100006 Kyle
Leah
2000-05-29
100007 Myers
Lynda
1980-08-24
N
Transcribed Image Text:DB Browser for SQLite - C:\Users\13309\OneDrive\Desktop\sqlite\LabAssignment3.sqlite File Edit View Tools Help @New Database Open Database Write Changes Revert Changes Open Project Save Project Attach Database X Close Database Database Structure Browse Data Edit Pragmas Execute SQL Table: STUDENT ba Filter in any column Is Active Filter StudentID StudentLastName StudentFirstName DOB Filter |Filter Filter Filter 1 100001 Johnson Ariel 1999-07-10 N 100002 Green Robin 2001-11-02 N 3 100003 Johnson Charles 1995-01-12 N 4 100004 Pearson Jeffery 1996-02-06 N 5 100005 Sears Miguel 1998-10-31 N 6 100006 Kyle Leah 2000-05-29 100007 Myers Lynda 1980-08-24 N
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education