Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
11. List the titles and the network id for all shows. Take a screenshot now and paste it here.

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

Database System Concepts
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
icon
Related questions
Question
[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)
Transcribed Image Text:[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)
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

SEE SOLUTIONCheck out a sample Q&A here
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
  • SEE MORE 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
SEE MORE TEXTBOOKS