Let us consider the following relational databases
- Students(id, name, address, dob, email, advisor)
id
name
Address
Dob
Advisor
950111111
Ann Smith
1 Main St.
1997-10-19
asmith@aggies.ncat.edu
950850123
950999999
Alan Turing
2 Lee St.
1988-08-10
aturning@aggies.ncat.edu
950850999
950111222
Karen Peters
4 Market St.
1998-01-02
kpeters@aggies.ncat.edu
950850999
950111333
Milo Bruni
15 Chelsea St.
1999-03-17
mbruni@aggies.ncat.edu
950850456
950111444
Jim Mattis
21 First St.
1992-09-04
jmattis@aggies.ncat.edu
950850999
950111555
John Kelly
33 Wall St
1995-05-05
jkelly@aggies.ncat.edu
950850123
- MajorsIn(studentID,deptName, enteredTerm)
studentID
deptName
enteredTerm
950111111
Graphic Design
Spring 2013
950111111
Computer Technology
Fall 2014
950999999
Information Technology
Fall 2015
950111222
Graphic Design
Fall 2014
950111222
Information Technology
Spring 2014
950111333
Graphic Design
Spring 2014
950111333
Information Technology
Spring 2015
950111444
Information Technology
Fall 2015
950111555
Computer Technology
Fall 2013
Write SQL queries that answer the questions below (one query perquestion) and run them on the MySQL Database System using batchmode. The query a answers must not contain duplicates,but you should use the SQL keyword distinct only when necessary.You should create the database before you start w writingqueries.
Retrieve the name of all
PayPal Gateway not configured
PayPal Gateway not configured