i). List the names of all the authors in the database, and beside each name give the number of books published on or after 2017 4.A database is built in the library to catalogue books and handle book lending.Each book in the library is catalogued by author. Any number of books can beassociated to an author. Each user is allowed to borrow one and only one book.The database stores information about the following entities and theirrelationships:User: unique reference number, name, and phone number,Author: unique reference number, name●Book: unique title, category (e.g. Physics, Science,..), publication year, theuser (reference) borrowing the book, the author (reference) of the book.

The SQL query is given below We have used INNER JOIN here.

Answered: i). List the names of all the authors…

i). List the names of all the authors in the database, and beside each name give the number of books published on or after 2017

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: 5. The HAVING clause can be used only with ...

A: Having clause is used to perform selection operation on the groups we have selected at the output…

Q: List the years and their total gross earnings (sum of earnings per year), but do not include gross…

A: ANSWER:-

Q: list of clauses in sql. Give examples of very clauses.

A: sql clause facilitates us to retrieve a hard and fast or bundles of information from the table. sql…

Q: Write SQL queries to answer the following questions:a. List the numbers of all sections of course…

A: To write an SQL query to list the numbers of all sections of course ISM 3113 thatare offered during…

Q: Use SQL and TAL Distributors database to complete the following questions: List the item number and…

A: List the item number and description for all items. The descriptions should appear in uppercase…

Q: SQL compile a list of all orders placed on day X by calculating the total number of repairs and the…

A: Solution: Note : You didn't mention the table schema so assume by myself. Given,

Q: ts: You will need to add data to both tables. Remember that the movie table has th duction co., not…

A: Description: 1- If a user wants to insert records one by one then needs to use the following…

Q: Make a list of how many albums each artist has released. Only include artists with more than 5…

A: To create a list of artists with more than 5 albums, we need to query the database tables and count…

Q: Display employees where the first name or last name starts with S. using sql plus hr user

A: To select data from a database, SELECT statement are used. The data is saved in a result table…

Q: Show all name and phone numbers of students and the type of donation they received including any…

A: Show all name and phone numbers of students and the type of donation they received including any…

Q: - Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy…

A: INSERT INTO query is used to copy the sql data from one table to another table.WHERE is SQL clause…

Q: How long was the longest delay before departure? Options: 1355 min 999 min 1099 min…

A: SELECT * FROM flights LIMIT 4; select origin,count(*) from ontime where year = (<YEAR>) origin…

Q: ? List each order number and the date it shipped. SQL comm

A: Solution - In the given question, we have to write the SQL command for the given query.

Q: Explain when you would prefer to use embedded SQL over SQL or a general-purpose programming…

A: Embedded SQL is a technique that allows SQL statements to be integrated directly into a…

Q: Using database, show the first name and birthday for all female staff whose birthday is before…

A: Introduction: The AND, OR, and NOT operators can be used with the WHERE clause. Records can be…

Q: Consider the Schema of the university database. Select SQL query to display a list of all students,…

A: Here we are given multple tables such as takes with primary key (ID, course_id, sec_id)student…

Q: database HR Display the last name, salary, and commission for all employees who earn…

A: /* Creation of EMP table, I am creating column EMP_FIRST_NAME and EMP_LAST_NAME instead of…

Q: Find the number of (unique) products that have been sold to more than 10 customers. SQL Question

A: We need to write a SQL query for finding the number of (unique) products that have been sold to more…

Q: 9. Find the total amount of tax paid by resident of NJ Hint: The tax cost stored in tax_amount…

A: Inner join is used to join two tables. Tax_amount column is given , to find sum value of a column.…

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition. student…

Q: Find the album title, band name, format, and total length of all albums released since January 1,…

A: SQL : In order to update, insert, delete, create and alter database tables and views, among other…

Q: Use SQL to write the following queries: a) Find the last names of students born after January 1,…

A: In this question we have to understand about the given SQL queries and suggest if these queries are…

Q: Using SQL Show the distinct location_id for all the locations where the company has departments

A: SQL SQL stands for Structured Query Language, and it is a programming language used to store,…

Q: For each different job_id group in the employee table, show the average salary and job_id for the…

A: SELECT Average_salary, Job_id FROM employees WHERE EXISTS (SELECT *…

Q: 2. Determine which orders haven’t yet shipped and the name of the customer who placed the order.…

A: According to the information given:- We have to follow the instruction in order to perform the…

Q: Use SQL and TAL Distributors database to complete the following questions: List the customer…

A: SELECT statement :- It is used to retrieve information from the table or database. The syntax for…

Q: Answer the query using SQL. For each department that controls more than 3 projects, retrieve the…

A: Introduction of DBMS: A database is a collection of data that are used to produce useful information…

Q: I. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: To write the SQL query.

Q: For every completed or 'open service request for janitorial work', list the condo id, description,…

A: The querry has given

Q: Explain extensIons to sQl?

A: A SQL file contains Structured search language (SQL), that may be a language wont to access and…

Q: 1. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: Structure of a table employee is given having attributes First_Name, Last_Name, SSN_Number.…

Q: 1. Report the student names and ages of all students who have a "hotmail" email address. Sort the…

A: 1. Report the student names and ages of all students who have a "hotmail" email address. Sort the…

Q: Determine the number of different customers who have placed an order for books written or cowritten…

A: 9. Determine the number of different customers who have placed an order for books written…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: Salary from highest to lowest Sorting emp name alphabet

A: Please find the answer below

Q: Display the current day of the week, hour, minutes, and seconds of the current date setting on the…

A: 5)SELECT TO_CHAR(CURRENT_DATE,'DAY,HH:MI:SS') FROM dual; (Or)

Q: Item Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors'…

A: Attribute (Simple): Simple qualities are ones that cannot be further subdivided. For example, in the…

Q: 2. Use RELATIONAL ALGEBRA to write the following queries: a) Find names and surnames of professors,…

A: In this question we have to understand about the schema provided to write a RELATIONAL ALGEBRA for…

Q: List the names of the production companies and the titles of their movies. This time, include all…

A: Given that, The names of the tables are Movie and Production Assume that, The attributes of Movie…

Q: A) Find all loan numbers with amount greater than $50,000. B) Find the names of all depositors who…

A: A) Find all loan numbers with amount greater than $50,000. σ(amount > 50000) (loan)

Q: 5. In the OrderItems table, display a count of the number of products where item_price is greater…

A: Algorithm:From the OrderItems tableFrom the OrderItems tableWhere item_price is greater than or…

Q: For each product, show the product ID and the number of orders placed. Show the results in…

A: Introduction: SQL (Structured Query Language) is a database computer language designed primarily for…

Concept explainers

Basic SQL Queries

Structured Query Language is the full form of SQL. It is a high-level language used to communicate with a relational database. It is used for creating, storing and accessing contents of a relational database. SQL is used to write the queries which are executed using database engines like Oracle, SQL Server and so forth.

Question

i). List the names of all the authors in the database, and beside each name give the number of books published on or after 2017

4.
A database is built in the library to catalogue books and handle book lending.
Each book in the library is catalogued by author. Any number of books can be
associated to an author. Each user is allowed to borrow one and only one book.
The database stores information about the following entities and their
relationships:
User: unique reference number, name, and phone number,
Author: unique reference number, name
●
Book: unique title, category (e.g. Physics, Science,..), publication year, the
user (reference) borrowing the book, the author (reference) of the book.

Organized collection of structured information, or data, typically stored in a computer system.

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

Query

VIEW

Explanation

VIEW

Step by step

Solved in 3 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

List the employee’s first and last name and the department name he/she does NOT belong topurchasing, shipping, or sales departments. Use Not operator.
List the names of all customers that have a credit limit of $7,500 or less
From worksheet Product, in cell 115, display the week number of the date given in cell 19. Answer: From worksheet Accessories, in cell 111, find the median of selling price. A hp
Please insert the data into the database tables
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
You are given the following schema of a University, where primary keys of each table are underlined and symbol (#) symbolises foreign keys: Student (student id, first_name, last_name, date_of_birth) Course (course_id, #professor_id, course_name, credits, programme) Exam (#student id, #course id, exam_date, grade) Professor (professor id, first_name, last_name, research_field)
Please don't copy
SQL Database Designs What do you think is the most important concept in SQL Database Designs
Show the employees who were in the engineering department as of Jan. 1, 2005 (using SQL)
5. Write an SQL statement to display all orders from the tables Catalog2015 and Catalog2016 for orders happened in 2016 not 2015. (CL0 e)
Display manager ID and number of employees managed bythe manager. using sql plus hr user
Please help: Using the following sql file, how would you find List all the rows in which the prescription dates occur on or after November 14. How many doctors provide prescriptions with 30 tablets in total? List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order Find all patients rows whose first names include ‘George’ (Assume case sensitivity). List number of patients that do not have a phone number. Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End; //* Assignment_1 */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…