List the ids, first names, last names, majors, minors, and advisor's faculty ids of students majoring or minoring in CSCI and having a faculty advisor in the following
Provide the MySQL commands for the following queries. Make sure that your
queries produce the exact output as shown (row order can be different).
[1] List the ids, first names, last names, majors, minors, and advisor's faculty ids of
students majoring or minoring in CSCI and having a faculty advisor in the following
manner.
+--------+-------+-------+-------+-------+---------+
| stuId | fname | lname | major | minor | advisor |
+--------+-------+-------+-------+-------+---------+
| 100000 | Tony | Hawk | CSCI | CINF | 1011 |
| 100001 | Mary | Hawk | CSCI | CINF | 1011 |
| 100002 | David | Hawk | CSCI | ITEC | 1012 |
| 100009 | Linda | King | ARTS | CSCI | 1018 |
+--------+-------+-------+-------+-------+---------+
4 rows in set (0.000 sec)
![MariaDB [toyu2]> select * from student;
stuId fname
| 1name
| Hawk
Hawk
Hawk
Lim
100000 Tony
100001 | Mary
100002 | David
100003 | Catherine
100004 Larry
100005 Linda
100006 Lillian
100007 Ben
100008 | Bill
100009 | Linda
100111 | Cathy
11 rows in set (0.000 sec)
| major | minor | credits | advisor |
CSCI
CINF
CSCI | CINF
CSCI
ITEC
ITEC
CINF
Johnson
ITEC
NULL
Johnson CINF
ENGL
Johnson
CINF
ITEC
NULL
NULL
ARTS
CSCI
Johanson NULL | NULL
Zico
Ching
King
NULL
ARTS
40
35
66
20
66
13
18
16
90
125
1011
1011
1012
NULL
1017
1015
1016
NULL |
NULL |
1018
1018](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F373ec5c3-fcc8-4cc5-a897-c792133242cb%2F136eb595-a5cb-476c-a6c9-b1d9cc959937%2F10khx5_processed.png&w=3840&q=75)
MySQL creates a database for storing and manipulating data defining the relationship of each table.
Step by step
Solved in 3 steps with 4 images
