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.sqliteFile Edit View Tools Help@New DatabaseOpen DatabaseWrite ChangesRevert ChangesOpen ProjectSave ProjectAttach DatabaseX Close DatabaseDatabase Structure Browse Data Edit Pragmas Execute SQLTable: STUDENTba Filter in any columnIs ActiveFilterStudentID StudentLastName StudentFirstNameDOBFilter|FilterFilterFilter1100001 JohnsonAriel1999-07-10N100002 GreenRobin2001-11-02N3100003 JohnsonCharles1995-01-12N4100004 PearsonJeffery1996-02-06N5100005 SearsMiguel1998-10-31N6100006 KyleLeah2000-05-29100007 MyersLynda1980-08-24N

Answered: Show the students’ first and last name…

Engineering

Computer Science

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

See similar textbooks

Related questions

Q: LIST THE FIRST AND LAST NAMES OF ALL OWNERS WHO OWN A TWO-BEDROOM PROPERTY. USE THE IN OPERATOR IN…

A: Considering there are 2 tables:- OWNER: which holds the OWNER_NUM, FIRST_NAME, and LAST_NAME…

Q: Create a query for displaying average commission percentage company is giving to its employees.…

A: Format of Query :- SELECT AVG ( coloum name ) AS aliasname FROM tablename; According To question :-…

Q: Given the table customers which contains columns customer_id, first_name, last_name, and state, and…

A: SELECT C.LASTNAME, A.STATE, A.ZIP FROM CUSTOMER AS C INNER JOIN ADDRESS AS A on…

Q: Write a query which shows the common last names of any individuals in both tables. Make sure you…

A: I have written query in next step.

Q: Question 6 (Must include subquery): Write, a query that returns every customer that has a loan at…

A: The query is given below with output screenshot Demo data has been used in tables

Q: Write a query to display the author ID, first and last name for all authors who have never written a…

A: The below query will return the author ID, first name, and last name for all authors who have never…

Q: Write a query to list the book subject and the number of books in each subject. Limit your result to…

A: SELECT – to query data in the database INSERT – to insert data into a table UPDATE – to update…

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Use a query to compute the total of all purchases, the number of purchases, and the average purchase…

A: SQL query The Round() function is used to round off the number to the desired decimal places. The…

Q: ind all the Nobel laureates, with the year of the award, who were born either in Poland (present but…

A: The query is needed to supplied in SQL.

Q: Display only the first 100 records of students table sorting last_name from Z to A.

A: here have to determine about sql query for given database problem statement.

Q: Write a query to display the book number, title and cost of books that have the lowest cost of any…

A: Query: In general, the term query describes a question or request that is made by a user or another…

Q: Write a query to print the names of all FaceX members who were born in the year 1985. .

A: Structured Query Language (SQL), a programming language used to manage and manipulate data stored in…

Q: Display only unique last_name from students table.

A: This question comes from Database Management System which is a paper of Computer Science. Let's…

Q: Add the OWNER_NUM column as a foreign key in the CONDO_UNIT table.

A: to Add the OWNER_NUM column as a foreign key in the CONDO_UNIT table, the script is mentioned in…

Q: Create a query for selecting Employee_Id , First_Name, Phone_Number where Department_ID is not in…

A: Create table and insert data into it CREATE TABLE EmpDetails( Employee_Id INT PRIMARY KEY ,…

Q: Write a query that displays the name and hiredate of any employee hired after 24 October 2000 and…

A: Query: Query means a request to retrieve data or information from databases. Query can be either…

Q: Display the employee's record who were hired on a specific date. The hiredate is entered by user run…

A: SQL is a structured query language, that's used to extract and manipulate the data from the table.…

Q: using the code write a query to display the movie number, movie title, movie cost, and movie genre…

A: 1. Create a table named MOVIE: - Define columns: - MOVIE_NUM as INT (Primary Key) -…

Q: Write a query to display the checkout number, book number, patron ID, checkout date, and due date…

A: The query follows the syntax given below. SELECT column1, column2 FROM table1 WHERE condition ORDER…

Q: Create a query to show the subject and the quantity of books in each category. Sort the results in…

A: Introduction: Important information to remember: Hey! I hope you're doing well! Thank you for your…

Q: Write a query to display student Id who registered for the course 1001, 1005. If they registered for…

A: SQL program is an given below for the students :

Q: Write a query to display the employee number, last name, first name, salary “from” date, salary end…

A: Solution: Given, Write a query to display the employee number, last name, first name, salary…

Q: Write a query to display the book title, price and publisher name for all books.

A: The question requires us to Write a query to Display the book title , price and the publisher name…

Concept explainers

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.

Question

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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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.

Similar questions

From the following query, identify the value of City: INSERT INTO Customers ( CustomerName, ContactName, Address, City, PostalCode, Country) VALUES (‘Cardinal,”Tom B. Erichsen”,”Skagen 21”, “Stavanger,” “4006Norway’);
Write the following as MySQL query: Find the employee ID, first and last name, and salary for each employee whose salary ismore than $20,000 or who works in the shipping department. Use the UNION set operator. List the country ID, country name, city, and state/province. Be sure all country names areincluded in the result, regardless of whether there is no matching city and state/province. You have to use an outer join.
Question 13 Write a query to display the last name, job of all employees whose last names starts with the letter "M".
database HR Write a query to display the last name, job, department number, and department name for all employees who work in Toronto.
3. Run a query that gives the average grade on the final exam for male students and for femalestudents. Round that number to 1 decimal place only.
Create a query for displaying first name of employees whose Initial is 'A' using instr() function.
Create a query to show the Technician Number, Last Name, First Name, Client Number,and Client Name for clients whose technician number is 23 (use Boolean variables).Save your query
How to code this query using mysql.