Question: Write SQL to answer the following question. 2.1 Provide the course code and description for any courses having a four-day duration.(2 Marks) Lessons Courses Code

Write SQL to answer the following question. 2.1 Provide the course

Write SQL to answer the following question.

2.1 Provide the course code and description for any courses having a four-day duration.(2 Marks)

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Database Management systems question please answer asap 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...

Q2 please provide answers for this SQL database question 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...

Q2 please provide answers for these SQL database questions Question 2 Use the tables (Courses and Lessons) below and the employees table in question 1. Write SQL to answer the following questions....

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

Database management system question Please answer asap 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...

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

ds/ITDIB2-B44%20-%20Initial%20Online%20Assessment%20Paper%20Block%204%202021%20(V1.0).p Block 4 2021 (V1.0).pdf 3 / 7 67% + Question 2 Use the tables (Courses and Lessons) below and the employees...

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

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 Dludila H Trainer Training...

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

Marvel Company, a local company, bought raw materials as ingredients in its products from Superman Coporation, a US company, for 35,000 US Dollars in 2016. Pertinent exchange rates relating to this...

a). There is a student at our school who speaks Spanish but not know Cat. b). There is a positive integer that is not the sum of square 3 numbers c). If a person WOMA and a parent than that If Person...

On April 1 , 2 0 2 6 , General Corporation signs a 5 - year lease to use office space. The present value of the monthly lease payments is $ 1 0 9 , 0 0 0 . How will the financial statements be...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Holding national saving constant, does an increase in net capital outflow increase, decrease, or have no effect on a countrys accumulation of domestic capital?

An article in USA Today (December 16, 2004) began President Bush said Wednesday that the White House will shore up the sliding dollar by working to cut record budget and trade deficits. a. According...

International trade in each of the following products has increased over time. Suggest some reasons this might be so. a. wheat b. banking services c. computer software d. automobiles