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...


please provide sql queries as soon as possible.


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

Extracted 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

Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here