Data Retrival from Two Tables

Jaya Prakash

i want to display the no of courses available in each dept Pls Help me i want to print courses for each department pls help me This Is MyTable

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Deepak Tewatia3y ago
Accepted answer
Hi jaya,

use the following query to display the no. of courses available in each dept:-
```
SELECT department.did, COUNT(coursedept.cid)
FROM coursedept
JOIN department ON coursedept.did = department.did
GROUP BY department.did;
```

Deepak Tewatia3y ago

Hi Jaya Prakash,
To display instructor names who are teaching 'c' and 'c++' use the below query:-

SELECT P.fname,P.lname FROM Person P
INNER JOIN Courseinstructor CI on P.pid = CI.pid
INNER JOIN course C ON CI.cid = c.cid
WHERE C.cName IN ('C', 'C++');

Jaya Prakash3y ago
how to display instructor names who are teaching 'c' and 'c++' help me with this also bro