mysql> DESC bookauthor;mysql> DESC author;mysql> DESC book;| Field| Туре| Field| Туре| FieldТур| int(11| varchaiauthor_order | int(11royaltyshare | decima:author_idisbn| author_id | int(1:| ssnlastname| firstname | varch:| phone| address| city| state| zip| varch:| varch:isbnvarI name| typepub_idI price| advanceI ytd_salesI pubdatevarvar| varch:| varch:| varch:| varch:| varch:| intdec| decintmysql> DESC bookeditor;| dat| Field| Туреmysql> DESC editor;mysql> DESC publisher;editor_id | int(11)| varchar(1| Fieldisbn| Field| Туреeditor_idssnpub_id | int(11)| varchar(40)varchar(40)varchar(20)varchar(2)lastnamenamefirstnameaddress| phoneeditor_positionsalary| citystate 3. Write a query that retrieves the following results (note the column names and order of results):| pub id | Publisher's Name| Total Sales |3 | All Techo Books1 | Sunshine Publishers2 | Binder and Smith24941 |25325 |43844 |

The required result needs to fetch below columns : Pub_id -> from publisher table Publisher's…

Answered: 3. Write a query that retrieves the…

Engineering

Computer Science

3. Write a query that retrieves the following results (note the column names and order of results):

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: create table emp ( eid number(7), fname char(20), lname char(20), salary number, primary key…

A: Since you have not provided the database name to write the SQL code so I am using MySQL database to…

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: Create the following table in your database with the following schema: Table: Users +- | Column Name…

A: create table Users(id int, name varchar(10),primary key (id)); insert into Users values(1, "Alice");…

Q: Write a query to display the author ID, first name, last name, and year of birth for all authors…

A: The below query will return a list of authors with their IDs, first names, last names, and birth…

Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…

A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…

Q: Which of the following is true? (refer to the tables in the JustLee Books database)a. If you…

A: True statement Here while truncating a table, new data can be added to the table. While changing…

Q: Database Q1: Which one of the following INSERT statements will successfully insert a single row?…

A: Find the appropriate answer for the sql database questions.

Q: Consider the following TWO relations: Instructor(ID, name, dept_name, salary) Teaches (ID,…

A: SQL stands for Structured Query Language.

Q: Q1) Please write. a query statement from emp table to display deptno 10â€™s empno, ename, sal, and a…

A: --> As new_sale is increased 15% that means it increases by 115 out of 100% which is 115/100 =…

Q: Question 15 Suppose that you have the following table created as: CREATE TABLE TAB1 (NAME VARCHAR2…

A: For this question we can decompose the name by using parsename. Parsename will decompose a full name…

Q: Develop a query to provide details about customer sales at the end of 2014. You want the output to…

A: SELECT Sale.ShipToCity, Customer.LastName, Sale.ShipDateFROM Sale JOIN Customer on Sale.CustID…

Q: Create a query that that returns staff members’ names (excluding doctors), their hourly rates,…

A: Create a query that that returns staff members’ names (excluding doctors), their hourly rates,…

Q: Question 10 When sorting query output, you use the key words 'sort by'. Question 10 options:…

A: The given question is false.

Q: column name

A: We need to select Which column name is valid? We've to Select one from: a. NUMBER_1$ b. NUMBER c.…

Q: with it, paste your code in a text file named Student.txt and save it in your task folder. Write the…

A: This is a SQL question, here first we have to create a table student with a given parameter, then we…

Q: Which group function can be used to perform a count that includes NULL values?

A: Group by functions are : SUM ( [ALL | DISTINCT ] expression ) AVG ( ALL | DISTINCT ] expression )…

Q: Using php and sql: create a query and any supporting PHP code that will output only messages from…

A: Query: Explain the PHP code which will connect with mysql or any other database and validate the…

Q: Write a ASQ statement to return to see all of the first names in the People table. SELECT first name…

A: We need to find the correct query for getting first names in the People table. *As the table is not…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

mysql> DESC bookauthor;
mysql> DESC author;
mysql> DESC book;
| Field
| Туре
| Field
| Туре
| Field
Тур
| int(11
| varchai
author_order | int(11
royaltyshare | decima:
author_id
isbn
| author_id | int(1:
| ssn
lastname
| firstname | varch:
| phone
| address
| city
| state
| zip
| varch:
| varch:
isbn
var
I name
| type
pub_id
I price
| advance
I ytd_sales
I pubdate
var
var
| varch:
| varch:
| varch:
| varch:
| varch:
| int
dec
| dec
int
mysql> DESC bookeditor;
| dat
| Field
| Туре
mysql> DESC editor;
mysql> DESC publisher;
editor_id | int(11)
| varchar(1
| Field
isbn
| Field
| Туре
editor_id
ssn
pub_id | int(11)
| varchar(40)
varchar(40)
varchar(20)
varchar(2)
lastname
name
firstname
address
| phone
editor_position
salary
| city
state

3. Write a query that retrieves the following results (note the column names and order of results):
| pub id | Publisher's Name
| Total Sales |
3 | All Techo Books
1 | Sunshine Publishers
2 | Binder and Smith
24941 |
25325 |
43844 |

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Analyzing the Logic

Query

Query Description

Sample output

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 1 images

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

1. Write a query that displays the first and last name of every patron, sorted by last name and then first name. Ensure the sort is case insensitive (50 rows) PAT_FNAME Vera Holly Cedric Cory Nadine Erika Gerald Ollie robert Keith PAT_LNAME Alvarado Anthony Baldwin Barry Blair Bowen Burke Cantrell carter Cooley
What is the most efficient way to access data when you have multiple tables? a) Use the VLOOKUP function to create formulas to add data from other tables b) Use an application like Microsoft Query to consolidate the data into one table c) Create relationships between tables d) Use Power Query to consolidate the data into one table
First normal form says: a. No nonkey columns depend on another nonkey column b. Every column that's not part of the primary key is fully dependent on the primary key. c. Eliminate repeated fields. d. None of the above
Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order. (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)
Which of the following statements is valid? (refer to the tables in the JustLee Books database.)a. SELECT title FROM booksWHERE retail<(SELECT cost FROM booksWHERE isbn = '9959789321');b. SELECT title FROM booksWHERE retail = (SELECT cost FROM booksWHERE isbn = '9959789321' ORDER BY cost);c. SELECT title FROM booksWHERE category IN (SELECT cost FROM orderitemsWHERE isbn = '9959789321');d. none of the above statements
Which operator should you use to find NULL values?
Problem 9 Write a query to count the number of invoices.
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.
Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.
Write a SELECT statement that returns the following columns from the PRODUCT_INFORMATION table. Sort the results by PRODUCT_ID in ascending order. 1. PRODUCT_ID 2. PRODUCT_NAME 3. LIST_PRICE ○ Use the TO_CHAR function to convert LIST_PRICE to a character string with the currency formatting Give this field an alias of PRICE
Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
When you don’t know the specific value to include in the criteria, you use a ____. a. limited query b. unfilled query c. tagged query d. parameter query