5. List all the network names and the show names in one single column in the result set. Sort alphabetically. Take a screenshot now and paste it here.

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter1: Getting Started With Excel
Section: Chapter Questions
Problem 1.5CP
icon
Related questions
Question

USE UNION TO COMBINE

15. List all the network names and the show names in one single column in the result set. Sort alphabetically.
Take a screenshot now and paste it here.
Transcribed Image Text:15. List all the network names and the show names in one single column in the result set. Sort alphabetically. Take a screenshot now and paste it here.
mysql> DESC NETWORKS;
| Field | Type
| Null | Key | Default | Extra
| id
| name
| int(11)
| varchar (20) | YES
| auto_increment |
|
| NO
PRI | NULL
| NULL
+.
2 rows in set (0.02 sec)
mysql> DESC SHOWS;
| Field
| Туре
| Null | Key | Default | Extra
| int(11)
| varchar(80) | NO
| ID
| Title
| Num_episodes | int(11)
[| Country
| Start
| End
| NO
| PRI
NULL
| auto_increment |
| NULL
| NULL
| NULL
| NULL
| NULL
| NO
|
| varchar(60) | NO
| int(11)
| int(11)
NO
| YES
[6 rows in set (0.00 sec)
[mysql> DESC SHOW_NETWORK;
[| Field
Туре
| Null | Key | Default | Extra |
[] SHOW_ID | int(11) | NO
[| NET_ID | int(11) | NO
| PRI | NULL
| PRI | NULL
2 rows in set (0.01 sec)
[
[mysql> SELECT * FROM SHOWS;
[] ID | Title
| Num_episodes | Country
| Start | End
+.
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
NULL |
1998 |
1 | Bluey
2018
|
|
2 | Bobby's World
|
1990
|
1997 | 2010 |
3 | Caillou
4 | Doc McStuffins
5 | Doki
6 | Family Guy
7 | Sofia the First
2012
2020 |
2013 | NULL |
1999 | NULL |
2013| 2018 |
|
1999 | NULL |
2016 | NULL |
1989 | NULL|
[ |
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
|
1989 | 1990 |
1992
1994 |
2009 |
2005
2012 | NULL |
2006 | 2013 |
+-
15 rows in set (0.01 sec)
mysql> SELECT * FROM NETWORKS;
+--
[] id | name
+-
1 | ABC Kids
|
|
2 | CBS
3 | Discovery Kids
4 | Disney
|5| Fox
Transcribed Image Text:mysql> DESC NETWORKS; | Field | Type | Null | Key | Default | Extra | id | name | int(11) | varchar (20) | YES | auto_increment | | | NO PRI | NULL | NULL +. 2 rows in set (0.02 sec) mysql> DESC SHOWS; | Field | Туре | Null | Key | Default | Extra | int(11) | varchar(80) | NO | ID | Title | Num_episodes | int(11) [| Country | Start | End | NO | PRI NULL | auto_increment | | NULL | NULL | NULL | NULL | NULL | NO | | varchar(60) | NO | int(11) | int(11) NO | YES [6 rows in set (0.00 sec) [mysql> DESC SHOW_NETWORK; [| Field Туре | Null | Key | Default | Extra | [] SHOW_ID | int(11) | NO [| NET_ID | int(11) | NO | PRI | NULL | PRI | NULL 2 rows in set (0.01 sec) [ [mysql> SELECT * FROM SHOWS; [] ID | Title | Num_episodes | Country | Start | End +. 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 NULL | 1998 | 1 | Bluey 2018 | | 2 | Bobby's World | 1990 | 1997 | 2010 | 3 | Caillou 4 | Doc McStuffins 5 | Doki 6 | Family Guy 7 | Sofia the First 2012 2020 | 2013 | NULL | 1999 | NULL | 2013| 2018 | | 1999 | NULL | 2016 | NULL | 1989 | NULL| [ | 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 | 1989 | 1990 | 1992 1994 | 2009 | 2005 2012 | NULL | 2006 | 2013 | +- 15 rows in set (0.01 sec) mysql> SELECT * FROM NETWORKS; +-- [] id | name +- 1 | ABC Kids | | 2 | CBS 3 | Discovery Kids 4 | Disney |5| Fox
Expert Solution
Table SHOWS:

Computer Science homework question answer, step 1, image 1

Table NETWORKS:

Computer Science homework question answer, step 2, image 1

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
LUP Decomposition
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L