Question 2 Use the tables (Courses and Lessons) below and the employees table in question 1. Write SQL to answer the following questions. 2.1 Provide the course code and description for any courses having a four-day duration. 2.2 Which courses have been held in JHB and/or in Pretoria? 2.3 Which employees took both the JAV and the DATA courses? 2.4 Print a list of all workers who did not attend the JAV training. Courses Lessons Code Description Duration Campus Attendant Subject DATA Database 4 days JHB 2001 DATA management JAV systems 2002 DATA JAV Java script 7 days Midrand 2003 JAV MATH Mathematics4 days Pretoria 2004 JAV ISY Information 3 days Pretoria DATA systems 2005 MATH HTML Hyper Text 4 days JHB 2006 PMT Markup 2007 ISY Language PMT Project 7 days Midrand management

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
icon
Related questions
Question

please provide sql queries as soon as possible.

Questlon 2
Use the tables (Courses and Lessons) below and the employees table in question 1. Write SQL to
answer the following questions.
2.1 Provide the course code and description for any courses having a four-day duration.
2.2 Which courses have been held in JHB and/or in Pretoria?
2.3 Which employees took both the JAV and the DATA courses?
2.4 Print a list of all workers who did not attend the JAV training.
Courses
Lessons
Code
Description
Duration Campus
Attendant Subject
DATA
Database
4 days
JHB
2001
DATA
management
JAV
systems
2002
DATA
JAV
Java script
7 days
Midrand
2003
JAV
MATH
Mathematics
4 days
Prétoria
2004
JAV
ISY
Information
3 days
Pretoria
DATA
systems
2005
MATH
HTML
Hyper Text 4 days
JHB
2006
PMT
Markup
2007
ISY
Language
Project
PMT
7 days
Midrand
management
Transcribed Image Text:Questlon 2 Use the tables (Courses and Lessons) below and the employees table in question 1. Write SQL to answer the following questions. 2.1 Provide the course code and description for any courses having a four-day duration. 2.2 Which courses have been held in JHB and/or in Pretoria? 2.3 Which employees took both the JAV and the DATA courses? 2.4 Print a list of all workers who did not attend the JAV training. Courses Lessons Code Description Duration Campus Attendant Subject DATA Database 4 days JHB 2001 DATA management JAV systems 2002 DATA JAV Java script 7 days Midrand 2003 JAV MATH Mathematics 4 days Prétoria 2004 JAV ISY Information 3 days Pretoria DATA systems 2005 MATH HTML Hyper Text 4 days JHB 2006 PMT Markup 2007 ISY Language Project PMT 7 days Midrand management
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
SQL Query
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.
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