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

2.2 Which courses have been held in JHB and/or in Pretoria? (3 Marks)

2.3 Which employees took both the JAV and the DATA courses? (5 Marks)

2.4 Print a list of all workers who did not attend the JAV training. (5 Marks)

Office location JHB Midrand Table 1: Employees eid sname Init job dept dob 2001 Stones S Admin HR 3-12-1980 2002 Johnson K Salesrep Sales 12-4-1991 2003 Nkosi F Manager Accounting 4-6-1978 2004 Dludla H Trainer Training 20-6-1985 2005 Dlamini J Manager HR 7-9-1976 2006 Pale K Admin HR 16-3-1997 2007 Peter M Trainer Training 14-4-1960 Pretoria JHB Pretoria Midrand JHB Lessons Courses Code DATA Attendant Subject 2001 DATA JAV 2002 DATA JAV 2003 JAV MATH 2004 JAV ISY Description Duration Campus Database 4 days JHB management systems Java script 7 days Midrand Mathematics 4 days Pretoria Information 3 days Pretoria systems Hyper Text 4 days JHB Markup Language Project 7 days Midrand management DATA MATH HTML 2005 2006 PMT 2007 ISY PMT