Write an appropriate SQL query to list the lecturers that teach more than one module.

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

Write an appropriate SQL query to list the lecturers that teach more than one module.

STUDENTS
STUDENT_ID STUDENT_NAME
S123456
S246810
S369121
S654321
S987654
PROG6212
WEDE220
MODULES
MODULE_ID MODULE_NAME
DATA6212
INPU221
PROG6211
STUDENT_ID
S123456
S123456
S246810
S369121
S369121
S369121
S987654
S987654
S987654
Neo
STUDENT_MODULES
20; 21; 22
Derek
Pedro
Thabo
Dominique
L578963
L876592
L916482
© The Independent Institute of Education (Pty) Ltd 2022
Database Intermediate
Desktop Publishing
Programming 2A
Programming 2B
Web Development (Intermediate)
MODULE_ID
DATA6212
INPU221
PROG6211
PROG6212
WEDE220
LECTURERS
LECTURER_ID LECTURER_NAME
Kwezi
Julia
Trevor
LECTURER_MODULES
MODULE_ID
STUDENT SURNAME
Petlele
Moore
Ntaba
PROG6211
Joe
PROG6212
L578963
L876592
Woolridge
DATA6212
DATA6212
INPU221
WEDE220
PROG6211
PROG6212
WEDE220
L916482
LECTURER_ID
L916482
L876592
MODULE_CREDIT
30
20
15
15
20
LECTURER_SURNAME
Mbete
Robins
January
Page 4 of 10
2022
Transcribed Image Text:STUDENTS STUDENT_ID STUDENT_NAME S123456 S246810 S369121 S654321 S987654 PROG6212 WEDE220 MODULES MODULE_ID MODULE_NAME DATA6212 INPU221 PROG6211 STUDENT_ID S123456 S123456 S246810 S369121 S369121 S369121 S987654 S987654 S987654 Neo STUDENT_MODULES 20; 21; 22 Derek Pedro Thabo Dominique L578963 L876592 L916482 © The Independent Institute of Education (Pty) Ltd 2022 Database Intermediate Desktop Publishing Programming 2A Programming 2B Web Development (Intermediate) MODULE_ID DATA6212 INPU221 PROG6211 PROG6212 WEDE220 LECTURERS LECTURER_ID LECTURER_NAME Kwezi Julia Trevor LECTURER_MODULES MODULE_ID STUDENT SURNAME Petlele Moore Ntaba PROG6211 Joe PROG6212 L578963 L876592 Woolridge DATA6212 DATA6212 INPU221 WEDE220 PROG6211 PROG6212 WEDE220 L916482 LECTURER_ID L916482 L876592 MODULE_CREDIT 30 20 15 15 20 LECTURER_SURNAME Mbete Robins January Page 4 of 10 2022
Sample results:
LECTURER
January, Trevor
Robins, Julia
NUMBER OF MODULES
2
2
Transcribed Image Text:Sample results: LECTURER January, Trevor Robins, Julia NUMBER OF MODULES 2 2
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

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