Create a view vTop_Course_count to list the top 2 most popular course names and the number of students took these two courses for all years. Below is a sample output. name mycount Java2 Data structure 10 Students sid first_name last_name birthday major zipcode Huang 1990-01-01 cs 1976-02-08 IT 1987-03-21Math 1947-08-25 Biology 07101 1997-01-25CS 1001 Austin 07123 Mary Claudia 1002 Smith 08348 1003 91384 Lee Lin 1004 Andrew 1005 Helen Wu 07083 1007 Sarah Lee 1995-09-15 IT 4101

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
MYSQL
Create a view vTop_Course_count to list the top 2 most popular course names and
the number of students took these two courses for all years. Below is a sample output.
| name
mycount
Java2
Data Structure
10
Students
sid
first_name last_name birthday
major
zipcode
Huang
1990-01-01 cs
1976-02-08 IT
1987-03-21 Math
1947-08-25 Biology 07101
1997-01-25 | CS
1995-09-15 IT
1988-01-15 |Nursing |07101
|07123
08348
1001
Austin
1002
Mary
Smith
1003
Claudia
Lee
91384
1004
Andrew
Lin
1005
Helen
Wu
07083
1007
1008
Sarah
Lee
4101
Andrew
|Huang
Courses
cid
name
credits
CPS1231 |Java1
14
CPS2231 Java2
CPS2232 Data Structure
CPS3500 Web Programming
CPS3740 Database Introduction 3
CPS5740 Database Systems
CPS5921 Data Mining
4
4
3
3
Students_Courses
sid
cid
year
semester grade
CPS2231 2013
CPS2231 2015
CPS2231 2014
CPS3740 2011
CPS2232 2014
CPS2232 2016
1001
Fall
A-
1003
Spring
Spring
A-
1004
1009
Fall
B-
1009
Fall
1001
1004
Fall
C+
CPS2232 2014
Spring
B+
Transcribed Image Text:MYSQL Create a view vTop_Course_count to list the top 2 most popular course names and the number of students took these two courses for all years. Below is a sample output. | name mycount Java2 Data Structure 10 Students sid first_name last_name birthday major zipcode Huang 1990-01-01 cs 1976-02-08 IT 1987-03-21 Math 1947-08-25 Biology 07101 1997-01-25 | CS 1995-09-15 IT 1988-01-15 |Nursing |07101 |07123 08348 1001 Austin 1002 Mary Smith 1003 Claudia Lee 91384 1004 Andrew Lin 1005 Helen Wu 07083 1007 1008 Sarah Lee 4101 Andrew |Huang Courses cid name credits CPS1231 |Java1 14 CPS2231 Java2 CPS2232 Data Structure CPS3500 Web Programming CPS3740 Database Introduction 3 CPS5740 Database Systems CPS5921 Data Mining 4 4 3 3 Students_Courses sid cid year semester grade CPS2231 2013 CPS2231 2015 CPS2231 2014 CPS3740 2011 CPS2232 2014 CPS2232 2016 1001 Fall A- 1003 Spring Spring A- 1004 1009 Fall B- 1009 Fall 1001 1004 Fall C+ CPS2232 2014 Spring B+
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY