Use the tables (Courses and Lessons) below and the employees table in question  Write SQL to answer the following questions. 

1 Provide the course code and description for any courses having a four-day duration.

2 Which courses have been held in JHB and/or in Pretoria? .

3 Which employees took both the JAV and the DATA courses? 

4 Print a list of all workers who did not attend the JAV training.

  

Transcribed Image Text:

Courses Code Description Duration Campus DATA Database 4 days JHB management systems Java script Mathematics Information JAV MATH ISY HTML PMT 7 days 4 days 3 days systems Hyper Text 4 days Markup Language Project management 7 days Midrand Pretoria Pretoria JHB Midrand Lessons Attendant Subject 2001 DATA JAV DATA JAV JAV DATA MATH PMT ISY 2002 2003 2004 2005 2006 2007 Courses Code Description Duration Campus DATA Database 4 days JHB management systems Java script Mathematics Information JAV MATH ISY HTML PMT 7 days 4 days 3 days systems Hyper Text 4 days Markup Language Project management 7 days Midrand Pretoria Pretoria JHB Midrand Lessons Attendant Subject 2001 DATA JAV DATA JAV JAV DATA MATH PMT ISY 2002 2003 2004 2005 2006 2007

Answer rating: 100% (QA)

Based on the provided tables lets write SQL queries to answer the given questions one by one 1 Provi... View the full answer