11. List the titles and the network id for all shows. Take a screenshot now and paste it here.

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
icon
Related questions
Question
[mysql> select * from shows;
| ID | Title
| Num_episodes | Country
| Start | End
net_id |
+---
1 | Bluey
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
2018 | NULL |
1990 | 1998 |
|
2 | Bobby's World
3| Caillou
|
1
|
|
5 |
1997 | 2010 |
2012 | 2020 |
2013 | NULL |
1999 | NULL |
2013| 2018 |
7
4 | Doc McStuffins
5 | Doki
6 | Family Guy
7 | Sofia the First
8 | SpongeBob SquarePants
9 | The Loud House
| 10 | The Simpsons
| 1 | Chip 'n Dale
12 | The Little Mermaid
| 13 | Little Einsteins
4
3|
5 |
4 |
|
1999 | NULL |
2016 | NULL |
1989 | NULL |
1989 | 1990 |
1992 | 1994
2005 | 2009
6
6 |
5 |
4 |
2
4
+----
13 rows in set (0.01 sec)
[mysql> select * from networks;
+---
| id | name
+
1 | АВС Кids
| 2 | CBS
|
3 | Discovery Kids
4 | Disney
|
5| Fox
|
6 | Nickelodeon
7 | Teletoon
+.
7 rows in set (0.00 sec)
[mysql> DESC NETWORKS;
| Field | Type
| Null | Key | Default | Extra
| int(11)
| varchar(20) | YES
| id
| name
| NO
| PRI | NULL
| auto_increment |
| NULL
|
+.
2 rows in set (0.01 sec)
[mysql> DESC SHOWS;
| Field
| Туре
| Null | Key | Default | Extra
| int(11)
| ID
| Title
| Num_episodes | int(11)
| Country
| Start
| End
| net_id
| NO
| varchar (80) | NO
| NO
| varchar (60) | NO
|
| PRI | NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| auto_increment |
| int(11)
| int(11)
| int(11)
| NO
| YES
| YES
+-
7 rows in set (0.01 sec)
Transcribed Image Text:[mysql> select * from shows; | ID | Title | Num_episodes | Country | Start | End net_id | +--- 1 | Bluey 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 2018 | NULL | 1990 | 1998 | | 2 | Bobby's World 3| Caillou | 1 | | 5 | 1997 | 2010 | 2012 | 2020 | 2013 | NULL | 1999 | NULL | 2013| 2018 | 7 4 | Doc McStuffins 5 | Doki 6 | Family Guy 7 | Sofia the First 8 | SpongeBob SquarePants 9 | The Loud House | 10 | The Simpsons | 1 | Chip 'n Dale 12 | The Little Mermaid | 13 | Little Einsteins 4 3| 5 | 4 | | 1999 | NULL | 2016 | NULL | 1989 | NULL | 1989 | 1990 | 1992 | 1994 2005 | 2009 6 6 | 5 | 4 | 2 4 +---- 13 rows in set (0.01 sec) [mysql> select * from networks; +--- | id | name + 1 | АВС Кids | 2 | CBS | 3 | Discovery Kids 4 | Disney | 5| Fox | 6 | Nickelodeon 7 | Teletoon +. 7 rows in set (0.00 sec) [mysql> DESC NETWORKS; | Field | Type | Null | Key | Default | Extra | int(11) | varchar(20) | YES | id | name | NO | PRI | NULL | auto_increment | | NULL | +. 2 rows in set (0.01 sec) [mysql> DESC SHOWS; | Field | Туре | Null | Key | Default | Extra | int(11) | ID | Title | Num_episodes | int(11) | Country | Start | End | net_id | NO | varchar (80) | NO | NO | varchar (60) | NO | | PRI | NULL | NULL | NULL | NULL | NULL | NULL | NULL | auto_increment | | int(11) | int(11) | int(11) | NO | YES | YES +- 7 rows in set (0.01 sec)
11. List the titles and the network id for all shows.
Take a screenshot now and paste it here.
12. List the titles and the network name for all shows.
Take a screenshot now and paste it here.
13. List the show id, title, network id, and network name for all shows.
Take a screenshot now and paste it here.
Transcribed Image Text:11. List the titles and the network id for all shows. Take a screenshot now and paste it here. 12. List the titles and the network name for all shows. Take a screenshot now and paste it here. 13. List the show id, title, network id, and network name for all shows. Take a screenshot now and paste it here.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Hyperlinks
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
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education