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.
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.
Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts
Section: Chapter Questions
Problem 3.7CP
Related questions
Question
USE UNION TO COMBINE
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.*
Transcribed Image Text:# MySQL Database Structure and Data
Below is a detailed description and data retrieval example from a MySQL database containing information about television networks and shows.
## Table Descriptions
### `NETWORKS` Table
- **Fields**:
- `id`: Integer, not null, primary key, auto-increment.
- `name`: Variable character (20), unique names of networks.
```plaintext
| Field | Type | Null | Key | Default | Extra |
|-------|--------------|------|-----|---------|----------------|
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | YES | UNI | NULL | |
```
### `SHOWS` Table
- **Fields**:
- `ID`: Integer, not null, primary key, auto-increment.
- `Title`: Variable character (80), title of the show.
- `Num_episodes`: Integer, number of episodes.
- `Country`: Variable character (60), country of origin.
- `Start`: Integer, start year.
- `End`: Integer, end year (null if still ongoing).
```plaintext
| Field | Type | Null | Key | Default | Extra |
|--------------|--------------|------|-----|---------|----------------|
| ID | int(11) | NO | PRI | NULL | auto_increment |
| Title | varchar(80) | NO | | NULL | |
| Num_episodes | int(11) | NO | | NULL | |
| Country | varchar(60) | NO | | NULL | |
| Start | int(11) | NO | | NULL | |
| End | int(11) | YES | | NULL | |
```
### `SHOW_NETWORK` Table
- **Fields**:
- `SHOW_ID`: Integer, not null, primary key.
- `NET_ID`: Integer, not null, primary key, linking shows to networks.
```plaintext
| Field | Type | Null | Key | Default | Extra |
|---------|---------|------|-----|---------|-------|
| SHOW_ID | int(11) | NO | PRI | NULL | |
Expert Solution
Table SHOWS:
Table NETWORKS:
Step by step
Solved in 4 steps with 3 images
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.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning