Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 PMTStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started