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

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

See similar textbooks

Similar questions

Show the employees who were in the engineering department as of Jan. 1, 2005 (using SQL)
databaes sql
Using php and sql: create a query that will output only the user_id and message for user_id 8
Which SQL Command is used to delete a table from the database: a) Update b) Alter c) Drop d) Select
Explain replace and translate functions in Oracle sql
SQLite Write syntax for two different methods to insert data into table in SQLite?
List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.) Order the output by category. From MT SQL 10th Edition
Explain how CRUD functions may be performed using the SQLiteOpenHelper and SQLiteCursor classes.
Describe the use of the CAST and CONVERT functions in SQL.
7. List the shipping city and state for the order that had the longest shipping delay. SQL commands
In SQL Server, you may choose between three distinct character data types: NVARCHAR, NVARCHAR, and NVARCHAR.