Indicate for each of the following SQL statements, how many tuples would be returned if it was run on the table of Articles given above. 1. SELECT NUMBER FROM ARTICLES WHERE YEAR < 2019;2. SELECT DISTINCT NUMBER FROM ARTICLES WHERE YEAR < 2019;3. SELECT AVG(YEAR) FROM ARTICLES GROUP BY PUBLICATION;4. SELECT NUMBER FROM ARTICLES WHERE TITLE LIKE ‘%D’; Consider the following relation:ARTICLES (NUMBER, TITLE, PUBLICATION, VOLUME, YEAR, STARTPAGE, ENDPAGE,TECHNICAL_REPORT_ID)The relation contains information on articles published in publications (Journals). Each articlehas a unique number, title, and information on where to find it (name of the publication, whatvolume, and on which pages is appearing), also the ID of the technical report is specified.The following is an illustration of the relation:NUMBERTITLEPUBLICATION| VOLUMEYEARSTARTPAGE ENDPAGETECHNICAL_REPORT_ID240Junior PC gamesSAJS15201914115387330Early ChildwoodSAJS142016799526330Early ChildwoodSAJS142016799565930Data DictionarySAJEMS13201621123374750SACJP_value vsEquilibriam1520201.499solved770Data missedSAJEMS1520201.6.89870Data missedNature33332020333389

Answer : Here, the table is given so we need to find out the answers to given queries: I have…

Answered: Indicate for each of the following SQL…

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

Question

Indicate for each of the following SQL statements, how many tuples would be returned
if it was run on the table of Articles given above.
1. SELECT NUMBER FROM ARTICLES WHERE YEAR < 2019;
2. SELECT DISTINCT NUMBER FROM ARTICLES WHERE YEAR < 2019;
3. SELECT AVG(YEAR) FROM ARTICLES GROUP BY PUBLICATION;
4. SELECT NUMBER FROM ARTICLES WHERE TITLE LIKE ‘%D’;

Consider the following relation:
ARTICLES (NUMBER, TITLE, PUBLICATION, VOLUME, YEAR, STARTPAGE, ENDPAGE,
TECHNICAL_REPORT_ID)
The relation contains information on articles published in publications (Journals). Each article
has a unique number, title, and information on where to find it (name of the publication, what
volume, and on which pages is appearing), also the ID of the technical report is specified.
The following is an illustration of the relation:
NUMBER
TITLE
PUBLICATION| VOLUME
YEAR
STARTPAGE ENDPAGE
TECHNICAL_REPORT_ID
240
Junior PC games
SAJS
15
2019
141
153
87
330
Early Childwood
SAJS
14
2016
79
95
26
330
Early Childwood
SAJS
14
2016
79
95
65
930
Data Dictionary
SAJEMS
13
2016
211
233
74
750
SACJ
P_value vs
Equilibriam
15
2020
1.
4
99
solved
770
Data missed
SAJEMS
15
2020
1.
6.
89
870
Data missed
Nature
3333
2020
33
33
89

Expert Solution

Trending now

This is a popular solution!

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