17. List the network names and the number of shows per network.Take a screenshot now and paste it here.18. List the average number of episodes in the table shows.Take a screenshot now and paste it here.19. List the name of the shows that have more episodes than the average number of episodes in the table shows.Use a subquery. Do not hardcode the average number (that you obtained in the previous question).Take a screenshot now and paste it here. [mysql> select * from shows;+--| ID | Title[+.1 | Bluey| 2 | Bobby's World|| Num_episodes | Country| Start | End| net_id |2018 | NULL ||53 | Australia |81 | USA110 | Canada136 | USA77 | Canada350 | USA109 | USA263 | USA81 | Singapore |685 | USA65 | USA31 | USA76 | USA105 | USA113 | USA13 | Caillou4 | Doc McStuffins|1990 | 1998 |1997 | 2010 |5 |7 |4 ||2012| 2020 |5 | Doki6 | Family Guy||2013 | NULL |1999 | NULL ||35 |2013 | 2018 |1999 | NULL|2016 | NULL |1989 | NULL|7 | Sofia the First8 | SpongeBob SquarePants9 | The Loud House| 10 | The Simpsons| 11 | Chip 'n Dale| 12 | The Little Mermaid| 13 | Little Einsteins15 | Daniel Tiger| 16 | Handy Manny466|1989 | 1990 ||2005 | 20092012 | NULL2006 | 2013 |5 |4 |2 |4 |19921994 |84 |+-.15 rows in set (0.00 sec)mysql> select * from networks;+-[] id | name[|2 | CBS3 | Discovery Kids4 | Disney5| Fox6 | Nickelodeon7 | Teletoon8| PBS1| ABC Kids+.8 rows in set (0.00 sec)[mysql> desc shows;| Field| Туре| Null | Key | Default | Extra| int(11)| ID[| Title| Num_episodes | int(11)| Country[] Start| End| net_id| auto_increment || NO| varchar (80) | NO| PRI | NULL| NULL| NULL| NULL| NULL| NULLMUL | NULL| NO|| varchar (60) | NO|| int(11)| int(11)| int(11)| NO| YES| YES7 rows in set (0.00 sec)mysql> desc networks;| Field | Type| Null | Key | Default | Extra| id| name| auto_increment|| int(11)| NOPRI | NULL| NULL| varchar(20) | YES|2 rows in set (0.00 sec)

17. To display the network names and number of shows per network, the query is: SELECT N.name,…

17. List the network names and the number of shows per network. Take a screenshot now and paste it here. 18. List the average number of episodes in the table shows. Take a screenshot now and paste it here. 19. List the name of the shows that have more episodes than the average number of episodes in the table shows. Use a subquery. Do not hardcode the average number (that you obtained in the previous question).

17. List the network names and the number of shows per network. Take a screenshot now and paste it here. 18. List the average number of episodes in the table shows. Take a screenshot now and paste it here. 19. List the name of the shows that have more episodes than the average number of episodes in the table shows. Use a subquery. Do not hardcode the average number (that you obtained in the previous question).

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: Which cards do not have a price recorded. Display all fields in the same column order as defined in…

A: Answer: We have to print table based on data given . here we will use SQL query to print data. we…

Q: Write a line of code that asks the user to Enter the original retail price , and stores the value…

A: The escape sequence for making text bold is '\033[1m'

Q: QUESTION 15 use the follwoing picture to answer the question Write a select statement which should…

A: Select INVENTORY.ITEM_SIZE, INVENTORY.COLOR, INVENTORY.CURR_PRICE,ORDER.ORDER_IDInner join on

Q: Download return data for your choice of stock from Yahoo Finance - closing prices from 20 September…

A: Download return data for your choice of stock from Yahoo Finance - closing prices from 20 September…

Q: Writing a query, calculate the total number of pages of books which are published in or after 1980…

A: SQL stands for Structured Query Language which is a query language that is used to insert, delete,…

Q: Determine what will be displayed by this code segment. game = 'Madden' user_name = Winner1…

A: '%' in print() statement followed by a character represents the type of value, of a variable, that…

Q: Use the HOL Small Company ERD and HOL Small Company Details xlsx to complete the steps listed below.…

A: 1. Write CREATE TABLE statements to create the tables listed below. Do not include constraints…

Q: Create a Movie table with the following columns: ID - positive integer with maximum value of 50,000…

A: The objective of the question is to create a SQL table named 'Movie' with specific columns and data…

Q: Write a SELECT statement that returns two columns based on the EMPLOYEES table. Contact, is the…

A: SELECT CONCAT(LastName," ",substring(FirstName,1,1)) as CONTACT, HomePhone as Phone FROM EMPLOYEES…

Q: Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on…

A: SQL query to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF…

Q: Write a SELECT statement that returns one row for each customer that has orders with these columns:…

A: The code you made:- SELECT email_address, COUNT(*) AS num_orders, SUM(quantity*(price-discount)) AS…

Q: Apply a Normal Form on the following table by drawing new table(s). Then answer question: which…

A: The given table can be change into new table by using 1st normal form -because all the cells in…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

Q: Use a LIST to store the sales data for each month with the three-letter abbreviation for the month…

A: Below i have given SQL queries:

Q: List all players for your Display the Team code and player number in a single column separated by a…

A: By changing the content in the table creation and information inserting by can achieve the solution:…

Q: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing…

A: sql command for the question is given in step 2

Q: Jump to level Complete the following statement to create a table named Country. Choose data types…

A: Here's the complete statement to create the Country table with the specified requirements and a…

Q: The Horse table has the following columns: ID - integer, primary key RegisteredName -…

A: Table Description:The table Horse has the following columns:ID: An integer column serving as the…

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

17. List the network names and the number of shows per network.
Take a screenshot now and paste it here.
18. List the average number of episodes in the table shows.
Take a screenshot now and paste it here.
19. List the name of the shows that have more episodes than the average number of episodes in the table shows.
Use a subquery. Do not hardcode the average number (that you obtained in the previous question).
Take a screenshot now and paste it here.

[mysql> select * from shows;
+--
| ID | Title
[+.
1 | Bluey
| 2 | Bobby's World
|
| Num_episodes | Country
| Start | End
| net_id |
2018 | NULL |
|
53 | Australia |
81 | USA
110 | Canada
136 | USA
77 | Canada
350 | USA
109 | USA
263 | USA
81 | Singapore |
685 | USA
65 | USA
31 | USA
76 | USA
105 | USA
113 | USA
1
3 | Caillou
4 | Doc McStuffins
|
1990 | 1998 |
1997 | 2010 |
5 |
7 |
4 |
|
2012| 2020 |
5 | Doki
6 | Family Guy
|
|
2013 | NULL |
1999 | NULL |
|
3
5 |
2013 | 2018 |
1999 | NULL|
2016 | NULL |
1989 | NULL|
7 | Sofia the First
8 | SpongeBob SquarePants
9 | The Loud House
| 10 | The Simpsons
| 11 | Chip 'n Dale
| 12 | The Little Mermaid
| 13 | Little Einsteins
15 | Daniel Tiger
| 16 | Handy Manny
4
6
6
|
1989 | 1990 |
|
2005 | 2009
2012 | NULL
2006 | 2013 |
5 |
4 |
2 |
4 |
1992
1994 |
8
4 |
+-.
15 rows in set (0.00 sec)
mysql> select * from networks;
+-
[] id | name
[|
2 | CBS
3 | Discovery Kids
4 | Disney
5| Fox
6 | Nickelodeon
7 | Teletoon
8| PBS
1| ABC Kids
+.
8 rows in set (0.00 sec)
[mysql> desc shows;
| Field
| Туре
| Null | Key | Default | Extra
| int(11)
| ID
[| Title
| Num_episodes | int(11)
| Country
[] Start
| End
| net_id
| auto_increment |
| NO
| varchar (80) | NO
| PRI | NULL
| NULL
| NULL
| NULL
| NULL
| NULL
MUL | NULL
| NO
|
| varchar (60) | NO
|
| int(11)
| int(11)
| int(11)
| NO
| YES
| YES
7 rows in set (0.00 sec)
mysql> desc networks;
| Field | Type
| Null | Key | Default | Extra
| id
| name
| auto_increment
|
| int(11)
| NO
PRI | NULL
| NULL
| varchar(20) | YES
|
2 rows in set (0.00 sec)

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

Step 1

VIEW

Step 2

VIEW

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

The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name and height for only horses that have an above average height. Order the results by height (ascending). Hint: Use a subquery to find the average height.
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!)
DONT COPY FROM CHEGG == REPORT + DISLIKE 9. List the genre name and count of all tracks in each genre, in descending order of track count (so the genre with the most tracks is listed first)
Modify the SELECT statement to select the title and release date of PG-13 movies that are released after February 1, 2008. Run your solution and verify the result table shows just the titles and release dates for The Dark Knight and Crazy Rich Asians. CREATE TABLE Movie ( ID INT AUTO_INCREMENT, Title VARCHAR(100), Rating CHAR(5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')), ReleaseDate DATE, PRIMARY KEY (ID)); INSERT INTO Movie (Title, Rating, ReleaseDate) VALUES ('Casablanca', 'PG', '1943-01-23'), ('Bridget Jones\'s Diary', 'PG-13', '2001-04-13'), ('The Dark Knight', 'PG-13', '2008-07-18'), ('Hidden Figures', 'PG', '2017-01-06'), ('Toy Story', 'G', '1995-11-22'), ('Rocky', 'PG', '1976-11-21'), ('Crazy Rich Asians', 'PG-13', '2018-08-15'); -- Modify the SELECT statement:SELECT *FROM MovieWHERE ReleaseDate < '2000-01-01';
1) Write the SQL code to add a column that shows the full name of the Employee in the Employee Table. The expecting format should be “Firstname Initial Lastname” (e.g., “John G News” for the EMP_NUM 101) 2) Write the SQL code to add a binary variable “Hire_prior_2000” in the Employee table. If the hire year (year of hire needs to be identified) is prior to 2000, then Hire_prior_2000=1, other wise Hire_prior_2000=0.
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
Below, we'll break down the differences between MonthCalendar and DateTimerPicker.
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
The APPT_DTTM column stores the date and time of an appointment. Which of the following expressions would return TRUE for all appointments on January 1, 2018, and FALSE for all other appointments? SELECT ONE OF THE FOLLOWING A. APPT_DTTM >= '1 JAN 2018' AND APPT_DTTM < '2 JAN 2018' B. APPT_DTTM = '1 JAN 2018' C. APPT_DTTM > '31 DEC 2017' AND APPT_DTTM <= '1 JAN 2018' D. APPT_DTTM > '31 DEC 2017' AND APPT_DTTM < '2 JAN 2018' Choose one correct answer and what is output of remaining queries with proper explanation
The Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020. -- Your SELECT statement goes hereSELECT *FROM HorseWHERE (Height >= '15.0' AND Height <= '16.0') OR BirthDate >= '2020-01-01';
he Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.
[SELECT productName, listPrice FROM products WHERE listPrice < 500 ORDER BY listPrice ASC].what will be the output? * productID categorylD productCode productName listPrice 1 1 strat Fender Stratocaster 699.00 1 les paul 1 sg 12 Gibson Les Paul 1199.00 Gibson SG 2517.00 1 fg700s Yamaha FG700S 489.99 1 washburn Washbun D10S 299.00 1 rodriguez Rodriguez Caballero 11 415.00 2 precision 2 hofner Fender Precision 799.99 Hofner Icon 499.99 3 ludwig Ludwig 5-piece Drum Set with Cymbals 699.99 Tama 5-Piece Drum Set with Cymbals 799.99 10 3 tama Your answer pick the form element from the following text box radio button. submit button. All of these