Discuss the below:
Q: As an exercise, which if you choose to accept,. Let's say we have the following tables with columns as such:
COURSE
COURSE COURSE COURSE DEPT
CODE NAME OFFERED CODE
POS410 SQL for Business Online IST
DBM380 Database Concepts Online IST
BUS101 Business Concepts Class BUS
DEPT
DEPT DEPT
CODE NAME
IST Information Systems and Technology
BUS Business
If I wanted to get the output to look as follows:
SQL for Business
|
Information Systems and Technology
|
Online
|
Q: What would my query look like? Although you don't need to build any tables with data, it would help to do this so you can test your sql query. In order to better understand sql you need to practice writing sql.